Simple IF formula not working
![NidhiK](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am trying to create a simple IF function for Status in a project plan template. The formula has no error but the required value is not populating based on the formula
=IF([% Complete]@row = "0%", "Not Started", IF([% Complete]@row > "0%", "In Progress", IF([% Complete]@row = "100%", "Complete")))
For example if I put 0% in % Complete cell then I should see Not started auto-populate in the Status Column. Its not populating Not Started...just is blank
Answers
-
If your '% Complete' column is populate with a decimal to make the %, such as 0 for 0%, .01 for 1% or .5 for 50%, etc.. then you are not going to want to use the "quotes" around the 0% in your formula. For example, try:
=IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row > 0, "In Progress", IF([% Complete]@row = 1, "Complete")))
Quotes around a value typically indicate its a string of text.
Hope this helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!