Trending in Formulas and Functions
-
Help with converting inherited Excel Formula
Hello, I have inherited this formula from an excel sheet that i can trying to get working in Smartsheet however as a novice... i am struggling. Grateful for any support. =IF(M10<=5,"Low",IF(AND(M10>=6,M10<=11),"Medium",IF(AND(M10>=15,M10<=25),"High",IF(AND(M10=12,K10=4),"High","Medium")))) Protonspounge
-
Help with a Harvey Ball formula
Hello everyone who's smarter than me: I need a formula to result in the following: Field empty if no start date listed Green ball if complete, regardless of start date Yellow ball if not complete and start date is within the next week Red ball if not complete and start date is in the past Gray ball if start date is more…
-
Revise Formula - RYG
I am using this formula: =IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", "Red") However, I need to revise it so that when column 3 (which is an additional column not mentioned in the original formula) contains a specific word, it changes my ball to yellow.