New: Formula custom fields (Calculation) 🧮

Manuel Oliveira
Manuel Oliveira Admin Posts: 1,007 COMMUNITY MANAGER
First Anniversary 5 Insightfuls 5 Likes First Comment
edited February 2023 in What's New #1

We are happy to announce that this often-requested feature is being released! Find out all about it here 🚀


What: You can make a numerical or monetary deal custom field calculate a value based on values from other deal fields.

For whom: Pro and Enterprise users

When: Gradual release starting February 2023

«1

Comments

  • Lucas MAGNE
    Lucas MAGNE Member Posts: 163
    First Anniversary Elite + Premier Solution Provider First Comment 5 Likes

    Awesome ! Can't wait to try it 💥

  • Alan Teece
    Alan Teece Member Posts: 8
    5 Likes First Anniversary First Comment Photogenic

    OK but very limited. What I really need is the ability to do mathematical operations on a custom field from many organisations - like doing a sum in excel on a column called 2023 Revenue. So I can then add up my revenue from hundreds of customers. Surely this can't be that hard?

  • Bruck
    Bruck Member Posts: 16
    Photogenic First Anniversary First Comment

    This was for me the most exciting news since it was one of the largest limitations of Pipedrive!!!

  • Max Jurock_8538
    Max Jurock_8538 Member Posts: 13
    5 Likes First Anniversary First Comment Photogenic

    Very excited to see this rolled out and have access to it!

  • Graham Cox
    Graham Cox Member Posts: 153
    First Anniversary First Comment 5 Up Votes 5 Likes

    Brilliant news, this will come in really handy, thanks Pipedrive.

  • Markus Funk
    Markus Funk Member Posts: 111
    First Anniversary 5 Likes 5 Up Votes Name Dropper

    Great can' wait to try it out as it will solve a lot of issues!

  • Mathias Brask
    Mathias Brask Member Posts: 51
    Photogenic 5 Likes Name Dropper First Comment

    @Manuel Oliveira , will this only work for deals or will it also be available for other parts of the products. For example the "products" module etc.?


    Also when stating that it is going to work on deals; will it be able to read the "cost of the associated products to a deal" and thereby make a calculation/sum of these products to calculate gross profit of a deal?


    That is kind of a nobrainer, since having the correct prices of deals is neccessary.

  • andrew_pag
    andrew_pag Member Posts: 1
    Photogenic First Comment

    I dont have this feature in my pipedrive... do I have to enable something for it to show up?


  • Bernd Auer
    Bernd Auer Member Posts: 344
    First Anniversary 5 Likes 5 Up Votes Name Dropper

    @Manuel Oliveira Still in BETA, right? :-) But would be great if add our PD Experts and PDX - Textumgebung to the test group. Can't wait to test it!

  • Manuel Oliveira
    Manuel Oliveira Admin Posts: 1,007 COMMUNITY MANAGER
    First Anniversary 5 Insightfuls 5 Likes First Comment

    Hi @andrew_pag , the release is gradual and will go on throughout February / March 2023. All going as expected, by the end of March all Pro / Enterprise users should see this feature 🚀

  • Manuel Oliveira
    Manuel Oliveira Admin Posts: 1,007 COMMUNITY MANAGER
    First Anniversary 5 Insightfuls 5 Likes First Comment

    Hi @Mathias Brask have a look in our knowledge base article here for more details on what this feature is able to do at launch.

  • Craig Beaumont
    Craig Beaumont Member Posts: 62
    5 Up Votes First Anniversary Name Dropper 5 Likes

    Will this be available to Advanced Plan users 🤞

  • Nico Müller
    Nico Müller Member Posts: 13
    First Anniversary First Comment Photogenic

    awesome! just learned it will be launched on the 24th of February! Really looking forward to that!

  • Mathias Brask
    Mathias Brask Member Posts: 51
    Photogenic 5 Likes Name Dropper First Comment

    @Manuel Oliveira unfortunately the knowledge base article is not describing anything about products. Will you be able to hand the feedback further on. Since you are now releasing a calculation field, it somehow must be in Pipedrive's interest to let its customers start calculating profit on their deals. At the moment such thing cannot be done, due to the limitations of products, despite that the "cost" of a product, is a standard field made available from Pipedrive.


    Would be awesome to have this added, and will finally open up for not having to use other software-tools etc, to calculate such a basic thing.


    Later on, you could enhance the future of such a solution so that triggers in workflows will be available based on the "numbers" in that calculation field etc.

  • Emma Melling
    Emma Melling Member Posts: 21
    First Anniversary Name Dropper 5 Likes First Comment

    It would be great to have this field available for organisations too. We would use this in conjunction with our custom fields to e.g. work out a cost per hire or % uptake etc

  • noone0909
    noone0909 Member Posts: 1
    First Comment Photogenic
    edited February 2023 #17

    testtesttesttesttesttesttesttesttesttesttesttest

  • Great feature, @Manuel Oliveira ! I would need to extend this feature to product fields. Our customers are asking for fields like net product price (typically net price= standard price -from products- * discount -from deal or organization-) to be calculated and used with Smart Docs to create automated quotations. Is is something we will see in the next weeks ?

  • Craig Beaumont
    Craig Beaumont Member Posts: 62
    5 Up Votes First Anniversary Name Dropper 5 Likes

    What he said @Gian Marco - InCodice

    This should be available to all subscription levels really as I would this this would be a fundamental feature for must for all businesses.🙏

  • Josh Buesking
    Josh Buesking Member Posts: 171
    5 Insightfuls First Anniversary First Comment First Answer
    edited February 2023 #20

    While this is needed in products more than anywhere else, I'm confident it will be there eventually. There's a lot of fields in the products side of things that are useless and from what I've been reading in various discussions, products is getting a huge overhaul.

  • Can it calculate commission based on 2 fields? For example deal value $ x commission % that is in another field that I have created?

  • Manuel Oliveira
    Manuel Oliveira Admin Posts: 1,007 COMMUNITY MANAGER
    First Anniversary 5 Insightfuls 5 Likes First Comment

    Hello everyone! We are very happy here at Pipedrive with your response to this new feature, and the feedback provided 🚀

    As mentioned in the knowledge base article here, this version of formula fields only applies to Deals for now. However, as we get the opportunity to review feedback and continue research, it could eventually extend to other items (people, organizations, etc). As of this comment, we are unfortunately not able to provide a timeline for such future updates as it won’t be in the very short term.

    Please do keep upvoting and sharing your use cases for improvements to this feature in Ideas and Product Feedback. Your input was fundamental in making this feature happen, and will continue to be 📝

  • Mathias Brask
    Mathias Brask Member Posts: 51
    Photogenic 5 Likes Name Dropper First Comment

    @Manuel Oliveira " it won’t be in the very short term." How come, you do develop such a functionality without thinking about extending it to other areas of your product?


    At the moment the calculation-abilities are very strict / limited, and seems like a beta-version compared to a better setup.?

  • Paul Minors
    Paul Minors Member Posts: 88
    First Anniversary 5 Up Votes Name Dropper 5 Likes

    Great feature which I'm really looking forward to using!

  • Hannes Kiivet
    Hannes Kiivet Pipedrive Team Posts: 2 PIPEDRIVE TEAM
    First Anniversary Name Dropper First Comment Photogenic

    @Mathias Brask, you are correct that the feature is quite limited, but you can rest assured that Pipedrive always develops functionality by thinking about extending it to other areas of our product. Personally, I would be super happy to provide all those SUM(), COUNT(), etc functions that work across all products, contacts, etc, but I am not our average customer 🙂 As with all modern SaaS companies we are rather releasing something very useful for most users, measuring takeup, collecting feedback, and then improving it with iterations. The current version of the formula feature is first released to the most used object in Pipedrive - deals - and after we have seen the initial take-up of the feature we plan to roll it out to other objects (incl. products). We have also included feedback collection in this feature usage flow so that we won't miss any of our users' ideas & suggestions.

  • Mathias Brask
    Mathias Brask Member Posts: 51
    Photogenic 5 Likes Name Dropper First Comment

    @Hannes Kiivet i see your point of view, and do agree on some parts of it.

    The most frustrating part at the moment (when using a deal) is the option of NOT being able to calculate "gross margin". It is key-figure to know when doing sales. Do we earn money or do we just sell... that is what such a number will show. And since we already do have a "cost" field on products (which can be related to deals), it then seems like a no-brainer that Pipedrive haven't solved this before. That could however be solved with a simple functionality of retrieving the cost-price of the associated products to the deal and then to a "product price minus product cost price = sum() and then you would have an awesome SaaS.

    At the moment integrating pipedrive with other systems (account-software) is not working probably, since sales agents would then need to use the accounting software aswell for calculating the gross margin etc. instead of just focusing on working entirely in Pipedrive.

    We are talking about hundred of hours that could be saved here...

  • Josh Buesking
    Josh Buesking Member Posts: 171
    5 Insightfuls First Anniversary First Comment First Answer

    There's lots of fields in products that aren't being used. They are roughed in but not much use. Via the api I can see there's variant descriptions but no way to input them.

    I'm hesitant to do much with more with products currently as they plan to update that part of the system this year and don't want to spend any time until they have.