I'm creating a CRM, I have 2 columns. One is the Sales stage with column properties (drop-down list) and the other is a probability% column with drop-down options.
I want a formula that will add the percentage from the drop-down options based on the sales stage that's selected.
Example if '1. Not Qualified' is chosen, I want 10% to be automatically added into the Probability% cell.
I'm really struggling, it would be so great if someone could help me with the exact formula I should be using.
Thanks in advance.
m: 0402 111 411
Help Article Resources
Check out the Formula Handbook template!