trouble with if then statement
I am wanting to setup a IF then statement, so when the percentage of cell A is 0 or 100, cell B changes from Not Started to Complete. I am using the following formula, which I adapted from MS Excel but it doesn't seem to be working. I am doing something wrong because it is not working.
=IF([% Complete]15 = 100, "Complete", "Not Started")
Note: Cell B is a drop down column, Cell A cell seems to be formatted to %, since I only have to put in 100 not 100%.
Thanks
Answers
-
Formula should be along the lines:
=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Completed", "In-Progress"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!