Need a formula for the Complexity Score
I have not been succesful trying to create a formula for the Complexity Score (currently shows a total of 9). If it less than 4, it show show ""Low" right below the total, if it is 58, it should show "Medium", if it is 9 or greater it should show "InDepth". Any assistance would be appreciated.
Best Answer

I will just use 10 for the row number where the score is. You may need to change that to fit whatever row it is actually on. I am also assuming that the column name is [Complexity Score]. You may also need to change that to match where in the sheet the number is.
=IF([Complexity Score]10>= 9, "InDepth", IF([Complexity Score]10>= 5, "Medium", "Low"))
Answers

I'm assuming the "9" comes from a SUM formula. If that's the case, you can trying something like this:
= IF(SUM(Column:Column) <= 4, SUM(Column:Column) + " (Low)", IF(AND(SUM(Column:Column) > 4, SUM(Column:Column) <= 8), SUM(Column:Column) + " (Medium)", IF(SUM(Column:Column) > 8, SUM(Column:Column) + " (High)")))
Let me know if that works or if you need more help troubleshooting! Happy to provide more assistance 😊

Thank you for your assistance. Unfortunately, that did not work. I'm sure I am still doing something incorrectly  even with your new formula. Where you have (Column:Column), I replaced that with (Complexity Score:Complexity Score) which is the column name. Was I correct in doing that?

I will just use 10 for the row number where the score is. You may need to change that to fit whatever row it is actually on. I am also assuming that the column name is [Complexity Score]. You may also need to change that to match where in the sheet the number is.
=IF([Complexity Score]10>= 9, "InDepth", IF([Complexity Score]10>= 5, "Medium", "Low"))

That did the trick! Thank you so much.

Happy to help. 👍️

@Don Bruns would you be willing to share this template with me. I'm trying to develop one in SMARTSHEET that I used to use in Excel but I'm also having trouble on how to accomplish that.
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!