Using Formulas to Automate Sales Tracking

Platform discussions
1

Hello!

Our team is using a board on Monday.com to track our Sales Pipeline. I am trying to figure out a formula that will automatically update our Close Probability when the Status is changed to something.

For example:
If the status = Initial Email/Call, then 5%
If the status = Follow Up Email/Call, then 10%
If the status = Meeting Booked, then 15%
If the status = Package Mailed, then 5%
If the status = Proposal/Quote Sent, then 25%
If the status = Proposal/Quote Received, then 40%
If the status = Negotiation, then 75%
If the status = Won, then 100%
If the status = Lost, then 0%
If the status = Cold Lead, then 0%

Can anyone help me create this formula? I cannot figure it out. Open to other suggestions as well for tracking the sales pipeline in Monday!

03%20AM
03%20AM1745×122 40.6 KB

1 Like
2

image

3

Hi Amanda,

sorry my english isn’t perfect.

I think , it’s what do you want :

SWITCH ({status},"Initial Email/Call,5%,
"Follow Up Email/Call’,10%,

etc
)

Best regards
Jean-Luc

4

Hi!

Thanks for your help. I tried this and it doesn’t seem to do anything. I just get an error. :frowning:

Thanks though!

5

Hi amanda_swys. Jean-Luc’s answer is the way to go. Probably you got a syntax error in the defined formula. Try the formula below.

SWITCH({Status},"Initial Email/Call","5%","Follow Up Email/Call","10%", "Meeting Booked","15%")

board
board1257×185 14.2 KB

2 Likes
6

I got this one to work! Thank you for your help!

2 Likes