Perform calculations in custom fields

Jaime Rojas
Jaime Rojas Member Posts: 1 VERIFIED MEMBER
Second Anniversary 5 Up Votes Photogenic
edited December 2023 in Ideas and Product Feedback #1

I believe it would be extremely helpful to provide the ability to perform calculations in custom fields. This would be even more useful if you could report on these custom fields. ie...calculate commissions on project value or calculate profit margins etc.

Thank you for the consideration!

12
12 votes

Completed · Last Updated

«13

Comments

  • Dmitri Ivanenko
    Dmitri Ivanenko Member Posts: 19 VERIFIED MEMBER
    10 Comments 5 Up Votes
    edited July 2022 #2

    We need calculated fields. I.e. if I have a field called Date of Birth, would be great if there was a self calculating field that shows age or when I create a template, to be able to do a formula. 

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,610 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 Answers
    edited December 2022 #3

    Yes, yes, an even more enthusiastic YES for this.

    The current solution is to use Zapier for this, but it wastes a lot of tasks credits.

  • Steve Johnson_827
    Steve Johnson_827 Member Posts: 7 VERIFIED MEMBER
    Second Anniversary Photogenic First Comment
    edited December 2022 #4

    Yes, I've asked PD for a simple age calculation from the day I became a user.  I'm curious about the Zapier solution and what is a task credit? 

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,063 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited December 2022 #5

    @Steve Johnson this is something we'd definitely consider exploring in the future. First up on our to-do list is mandatory fields though when it comes to fields, so stay tuned :) 

  • Dailius Wilson
    Dailius Wilson Member Posts: 10 VERIFIED MEMBER
    First Comment
    edited December 2022 #6

    Agreed im happy to demonstrate how to do this in zap for anyone interested too!

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,610 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 Answers
    edited December 2022 #7

    Yes, I've asked PD for a simple age calculation from the day I became a user.  I'm curious about the Zapier solution and what is a task credit? 

    Every action step in an automation consumes one task credit in Zapier. A task credit is the currency/unit that you get when you subscribe for a paid plan.

    In Zapier, set up a trigger for 'Deal is updated', and opt for mathematical calculations in the action step (if required), and then use the result to update the deal.

    In your case, now() - deal creation date should give you the most recent age calculation. 

  • Pete Mahon
    Pete Mahon Member Posts: 7 VERIFIED MEMBER
    10 Comments
    edited December 2022 #8

    Yes, yes, an even more enthusiastic YES for this.

    The current solution is to use Zapier for this, but it wastes a lot of tasks credits.

    I use Integromat for anything like this - works a treat, way more capable than Zapier. Cheaper too.

  • Michael Phillips
    Michael Phillips Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #9

    Another vote for calculated fields 

  • Bob_8561
    Bob_8561 Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #10

    Yes, calculated fields please...

  • Aleksei Mogutov
    Aleksei Mogutov Member Posts: 4 VERIFIED MEMBER
    First Comment
    edited December 2022 #11

    One more vote for calculated fields

  • Bronwyn Clarke
    Bronwyn Clarke Member Posts: 2 VERIFIED MEMBER
    First Comment
    edited December 2022 #12

    100 votes for calculated fields 

  • Mike McNally
    Mike McNally Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #13

    Calculated fields is an important missing feature in Pipedrive.  I have many uses for such a field type.  It would be ultimately handy if the resultant of the calculation could select an input on a single option list.

  • Gustavo Lima dos Santos
    Gustavo Lima dos Santos Member Posts: 3 VERIFIED MEMBER
    First Comment
    edited December 2022 #14

    Calculated fields, calculated fields... Please Guys!! 

  • Bronwyn Clarke
    Bronwyn Clarke Member Posts: 2 VERIFIED MEMBER
    First Comment
    edited December 2022 #15

    @Steve Johnson this is something we'd definitely consider exploring in the future. First up on our to-do list is mandatory fields though when it comes to fields, so stay tuned :) 

    Hi Mike .. any updates on calculated fields ?

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,063 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited December 2022 #16

    @Steve Johnson this is something we'd definitely consider exploring in the future. First up on our to-do list is mandatory fields though when it comes to fields, so stay tuned :) 

    Hi @Bronwyn Clarke unfortunately there's no update. Our team currently is working on other priorities sorry!

  • Robert Schulze
    Robert Schulze Member Posts: 9 VERIFIED MEMBER
    First Comment
    edited December 2022 #17

    Vote

  • Stefan Janciga
    Stefan Janciga Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #18

    Another 100 votes for calculated fields, please! 

  • Youness Elouargui
    Youness Elouargui Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #19

    We need to update the deal value automaticaly based on our custom fields values, please please 1000000 votes for calculated fields , please

  • John Katsougrakis
    John Katsougrakis Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #20

    I want to have a commitment date on a contract, which calculates 45 days from a contract date.  It is very important we have a calculated date field.

  • Aleksei Mogutov
    Aleksei Mogutov Member Posts: 4 VERIFIED MEMBER
    First Comment
    edited December 2022 #21

    @John Katsougrakis It was mentioned above that the only way around at the moment is Zapier. You can consider it if it is critical for you. 

    Otherwise I have a long list of examples where I would use calculated fields. It should not be a huge development, so I really hope that we all will be heard soon.

  • John Williams_23283
    John Williams_23283 Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #22

    I've run the numbers.  The math on calculated fields checks out.  Please add feature!

  • Alex Gero
    Alex Gero Member Posts: 8 VERIFIED MEMBER
    First Comment
    edited December 2022 #23

    Pipedrive really needs to implement this, I feel like this is very standard in other CRM systems and I'm surprised there is no update on this

  • Ann Hamilton
    Ann Hamilton Member Posts: 6 VERIFIED MEMBER
    5 Up Votes First Comment Photogenic First Anniversary
    edited December 2022 #24

    1000 times PD should have calculated fields capability!  Huge miss here.....

     

    PD admin peeps....any updates?

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,063 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited December 2022 #25

    1000 times PD should have calculated fields capability!  Huge miss here.....

     

    PD admin peeps....any updates?

    Hi @Ann Hamilton thanks for writing. It's definitely on the wish list but so far other things have gotten priority over it unfortunately.

  • Bill Barlas
    Bill Barlas Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #26

    1000 times PD should have calculated fields capability!  Huge miss here.....

     

    PD admin peeps....any updates?

    Can you share the roadmap of when? I have people asking for this all the time...

     

  • Olivier LEFEBVRE
    Olivier LEFEBVRE Member Posts: 4 VERIFIED MEMBER
    First Comment
    edited December 2022 #27

    1000 times PD should have calculated fields capability!  Huge miss here.....

     

    PD admin peeps....any updates?

    I don't understand what can be more important than a SO BASIC ability as to calculate fields... 🤷‍♂️

    Please guys, don't make the same mistake than your competitors : when your clients ask you for a terribly missing feature, listen to them. 😳

    To be forced to go through Zapier just to do an addition or a multiplication is nonsense! 🤦‍♂️

  • Alex Gero
    Alex Gero Member Posts: 8 VERIFIED MEMBER
    First Comment
    edited December 2022 #28

    1000 times PD should have calculated fields capability!  Huge miss here.....

     

    PD admin peeps....any updates?

    Completely agree with Bill and Oliver. Huge mistake in dismissing the importance of this. I get that implementing calculated fields doesn't make for a shiny new product video but it's a huge capability miss. I think you might be underestimating the importance of this in helping bring in new (especially bigger) customers and also retaining existing ones as they grow.

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,063 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited December 2022 #29

    1000 times PD should have calculated fields capability!  Huge miss here.....

     

    PD admin peeps....any updates?

    Hi @Bill Barlas @Olivier and @Alex Gero 

    Thank you for your comments here. I'm going to connect with our team working on the data fields here at Pipedrive. I wish I could make you any promises but unfortunately I can't :( 

    I hope you understand that prioritising for all our customers is one of the hardest things to do. We try to give you some sneak peaks of what we're working on here. And also hope that you continue to enjoy what we are releasing and communicating over here.

    I will do my best to make sure that your words here are heard and the team will look into this. 

  • John Stephenson
    John Stephenson Member Posts: 2 VERIFIED MEMBER
    Third Anniversary Photogenic First Comment
    edited December 2022 #30

    Must add this, for so many reasons.

  • 3Bee per l'Apicoltura
    3Bee per l'Apicoltura Member Posts: 1 VERIFIED MEMBER
    First Comment
    edited December 2022 #31

    1000 times PD should have calculated fields capability!  Huge miss here.....

     

    PD admin peeps....any updates?

    PLEASE ADD CALCULATED FIELD. Documents without that feature are quite useless. Listen to your clients

This discussion has been closed.