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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 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!