Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula Help to change a drop down list
I am not very good with formulas and have attempted to create one, but it doesn't seem to be working.
I have a % complete column and then a "drop down" status column with "complete, in progress, not started and at risk". What I'd like to do is set up a formula that says if % complete is 100%, then status changes to "complete". If I can work it so other percentages are covered too, that would be awesome, but mainly I want the complete status.
Is this even an option? Thanks!
Comments
-
Found the answer in another community answer - thanks Bob Stevens!
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives