% Formula based on another column
Hello - looking for a formula for reading another column drop down selection (Not started, In progress, Blocked, Complete). So when drop down is selected percentage column changes base don that value.
Not Started = 0%
In Progress = 50%
Blocked = 0%
Complete = 100%
thank you in advance
Answers
-
Hi @Morris R,
You can do this with a nested IF (make sure your Percentage column is set to % from the tool bar):
=IF(Status@row = "Complete", 1, IF(Status@row = "In Progress", 0.5, IF(OR(Status@row = "Not Started", Status@row = "Blocked"), 0, "")))
This should give the relevant percentage for the status types outlined and otherwise be blank.
Hope this helps, but if you've any problems/questions then just let us know!
-
Hi @Morris R ,
You can use a nested IF statement to do that. I'd recommend making it a column formula as well.
=IF([Status Dropdown]@row = "Complete", 1, IF([Status Dropdown]@row = "In Progress", 0.5, IF([Status Dropdown]@row = "Blocked", 0, IF([Status Dropdown]@row = "Not Started", 0, "--"))))
Thanks,
Sam
—
Want to chat about a Smartsheet problem you're facing? Grab time on my calendar here: Schedule a Discovery Call! -
Awesome ! thank you - worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!