Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Nested IF Statements
Comments
-
Sergio,
You have formatted your % complete column as <%>, remove the % formatting and your argument will produce the correct result.
-
Sergio,
You could also try
=IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 1, "Green", "Yellow"))
Change your IF([% Complete]3 = 100 to IF([% Complete]3 = 1. When it's looking at your % formatted column it sees 1 as 100%, .9 as 90% etc.(I believe putting 100 would make it look for 10,000%)
That way you can keep your % Complete column to % formatting.
-
Sergio,
As Jeremy mentioned above. You may need to change the data formatting or your formula. Unless you have 100% inputed as a string, 100% is being evaluated as 1 currently in your sheet.
-
Hi guys! Thanks for you help.
=IF([%complete]19 <70, "Red" ,IF([%complete]19=100, "Green" ,"Yellow")) STILL didn't work. I got an error message
-
proe,
You'll need to use the values 0.70 and 1
100% = 1 for the purpose of comparisons. Hope this helps!
Cheers,
Ben
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives