Invalid operation with IF Formulas
Hello Smartsheet Community,
I am struggling to figure out this IF Statement.
Smartsheet tells me this is a Invalid Operation
=IF([Use Case Development % Complete]@row = 1, "Completed", IF([Use Case Development % Complete]@row = <1, "In progress", IF([Use Case Development % Complete]@row = 0, "Not Started")))
What am I missing? This worked for another cell.
Answers
-
The issue is with the = < 1. You can either use equals OR less than but not both.
On a different note, you should put the =0 argument before the <1 (the way you currently have it, the <1 will always be valid before the =0 and you will never see "Not Started").
=(IF(% complete@row = 1, "Complete", IF(% complete@row = 0, "Not started", IF(% complete@row < 1, "In Progress")))
Yanis.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!