Formula with a range
Hi,
Calling on all formula guru's. I can get my formula to work for the absolute parts but when it comes to a range I get the #unparseable error. Below are the two formula's I've tried.
=IF([% complete]@row = 1, "Complete", IF([% complete]@row = 0, "Not Started"), IF([% complete]@row > .01 and <.1, "In Progress")))
=IF([% complete]@row = 1, "Complete", IF([% complete]@row = 0, "Not Started"), IF([% complete]@row = .01-.99, "In Progress")))
Thanks!
Best Answers
-
If your Complete column is blank you can use this formula. This way you don't need to have a range.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
Let me know if that works for you!
-
Thank you so much!
Answers
-
If your Complete column is blank you can use this formula. This way you don't need to have a range.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started"))
Let me know if that works for you!
-
Thank you so much!
-
You're very welcome!🙂
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
