IF Statement Statuses need values next to each Status Name


I am trying to create the following with the IF Statement but i’m having an issue why the toher status columns are not following suit

Status Column Names:
City and Utility
Schedule Installation
Installation Started
Request Engineering
On Hold

I want a Formula value column called Milestone Values next to these “Statuses”

Example below but It is only working on 1 of the statuses what am I doing wrong?

Any assistance would be greatly appreciated,

I want to associate each status name with a value, 1 = City and Utility and next Status “Schedule Install” = 2 and so forth

Hope that makes sense



Here’s one simple way:

IF({Milestone} = "City and Utility", 1, 0) +
IF({Milestone} = "Schedule Installation", 2, 0) +
IF({Milestone} = "Installation Started", 3 ,0) + ....

Jim - The Monday Man (YouTube Channel)
We Create Custom Solutions
What is Make & How can it help you?
Schedule a 1-on-1 Tutorial Session (monday, Make or Physics)

Thanks Jim! I appreciate it that worked like a charm


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.