Help! need help with my project health formula

AClark200 ✭✭
edited 02/22/24 in Formulas and Functions

My project health column is based on Expected Progress column. Works great with the exception where there there's no data (blank cell) the formula returns #INVALID OPERATION

I've tried adding a IF(OR(ISBLANK but haven't been able to get it correct. Would appreciate help/guidance!. Thank you

=IF([% Complete]@row = 1, "Blue", IF(OR(([Expected Progress]@row - [% Complete]@row) < 0.1, [% Complete]@row >= [Expected Progress]@row), "Green", IF(AND(([Expected Progress]@row - [% Complete]@row) >= 0.1, ([Expected Progress]@row - [% Complete]@row) <= 0.25), "Yellow", IF(([Expected Progress]@row - [% Complete]@row) > 0.25, "Red", ""))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!