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
- 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
Check out the Formula Handbook template!