Symbol Formula
Hi
My Formula all works except the "Complete section- if I change the Status column to 100 it remains "In Progess"
=IF([% complete]@row = 0, "Not Started", IF([% complete]@row < 100, "In Progress", IF([% complete]@row = 100, "Complete", "")))
Best Answers
-
Hi @Susan van Niekerk, you're so close. Try this formula:
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
Cheers,
Ric!
-
Happy to help!
Answers
-
Hi @Susan van Niekerk, you're so close. Try this formula:
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
Cheers,
Ric!
-
THAN K YOU :-)
-
Happy to help!
Help Article Resources
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!