IF Formula Help
Im looking for help with an IF type formula that would return one of the below ratings "Strong,
Average, Weak" based on the score in the first column and the indicative range sample in the third column. Im sure its something simple but it's got me stumped at present. Thanks in advance Rob
Best Answer
-
=IF([percentage Score]@row>85,"Strong",IF([percentage Score]@row<65,"Weak","Average"))
Answers
-
=IF([percentage Score]@row>85,"Strong",IF([percentage Score]@row<65,"Weak","Average"))
-
worked great just changed the percentages to 0.85 and 0.65 thanks for the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!
