IF Statement Statuses need values next to each Status Name

[jamesb33]

Hi,

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
Cancelled
On Hold
PENDING CANCEL

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

Cheers,
James

[JCorrell]

@jamesb33

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)

[jamesb33]

Thanks Jim! I appreciate it that worked like a charm

Cheers,
james