"=IF" statement not generating correct response all of the time
Hi Everyone!
I am trying to get my status column to change based upon what the number is the [% Complete) column is. Here is what I would like the desired results to be:
0= "Not Started"; 100="Complete"; and anything else from 1-99 would be "In Progress"
Here is the formula that I have tried, but it's not catching that 100% should be "Complete".
=IF([% Complete]@row = 100, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
Here is screenshot of the error.
Best Answer
-
You are very close. Smartsheet reads percentages as a decimal. so 100% = 1, 50% = 0.5, etc. All we need to do is adjust accordingly.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
Answers
-
You are very close. Smartsheet reads percentages as a decimal. so 100% = 1, 50% = 0.5, etc. All we need to do is adjust accordingly.
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", "In Progress"))
-
OMG, I wish I had asked sooner, I spent 3 days trying to figure this out on my own. Thank you soooo much!!!
-
Happy to help! 👍️
Don't hesitate to visit/reach out to the Community. There is a lot of knowledge floating around here, and even if you figure the answer out, you can always Comment on your own question with the solution and flag it as the Accepted Answer. That way if anyone else happens to be encountering the same problem or looking for a similar solution, they might be able to learn from your post.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- New program proposals are submitted via a form and collected on Sheet 1. When approved by a team leader, the row is copied to Sheet 2. I want to capture the date the copied occurred, which I thought w…
- I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
- Hi, I'm looking to write a formula using references to a rate sheet (screenshot attached with sensitive information redacted). We have several types of rates here, and also ones that are per word, whi…