Nested IF and percents
Answers
-
Hello @Paul Newcome,
Can you help me with the syntax as well please?
=IF([% Complete 2023-Q1]@row =0, "Not Started"),
IF(AND([% Complete 2023-Q1]@row > 0 and <= 0.25, "Initial Progress"),
IF(AND([% Complete 2023-Q1]@row > .25 and <= 0.50, "Mid-way Progress"),
IF(AND([% Complete 2023-Q1]@row > .51 and <= 0.90 "Major Progress"),
IF([% Complete 2023-Q1]@row =1, "Completed")))))
Basically if progress is 0 then not stargted
1-25% = Initial progress
26-50-mid-way progress
51-90 Major progress
Above formula results to unparseable
Thanks in advance.
IPC
-
Hi @IPC,
This formula should do what you're after:
=IF([% Complete 2023-Q1]@row = 0, "Not Started", IF([% Complete 2023-Q1]@row <= 0.25, "Initial Progress", IF([% Complete 2023-Q1]@row <= 0.5, "Mid-way progress", IF([% Complete 2023-Q1]@row <= 0.9, "Major Progress", IF([% Complete 2023-Q1]@row = 1, "Completed")))))
Output:
There is small gap where nothing is returned between 90 and 100%, but other than that it fulfils your requirements.
If you've any additional questions or comments then just post! 😊
-
What about 91% - 99%?
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!