Formula fields using dates, substracting date fields and field format

Mauricio Dabdoub_26700
Mauricio Dabdoub_26700 Member Posts: 13 VERIFIED MEMBER
Fourth Anniversary 10 Comments Photogenic
  1. Would be a big value to have formula fields to substrac date fields which results in days quantity, example (expected close date - last activity date = xyz days) or (end contract date - current day = abc days).
  2. Also should be nice to have the option to use the "month" or the "year" part of a date in some deals (capital or lower case options), for example to add to a title, "Deal 14500 - JUNE) for a deal created in June or close expected date, etc
Tagged:
2
2 votes

Submitted · Last Updated

Comments

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,648 VERIFIED MEMBER
    Fifth Anniversary 1000 Comments 250 Likes 25 Answers

    I would do this with one of Relay.app, Make, or Zapier.

  • Mauricio Dabdoub_26700
    Mauricio Dabdoub_26700 Member Posts: 13 VERIFIED MEMBER
    Fourth Anniversary 10 Comments Photogenic
    edited May 15 #3

    thanks for comments, of course you can do on that way, but should be a native option inside Pipedrive instead looking for adding integrations or any external environment. Should be easy and fast to define those formulas.

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,648 VERIFIED MEMBER
    Fifth Anniversary 1000 Comments 250 Likes 25 Answers

    I wouldn't hold my breath for Pipedrive to deliver these features/requests. So my reply was for people who are looking for an immediate solution.