jamesb33
(James B)
1
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
(Jim - The Monday Man)
2
@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
(James B)
3
Thanks Jim! I appreciate it that worked like a charm
Cheers,
james
system
(system)
Closed
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.