Help! need help with my project health formula

AClark200

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", ""))))

Jason Albrecht

Hello @AClark200

It looks like you've asked the same question with this post, where I have replied with a clarifying question and proposed formula.

Help! Expected Progress Formula #INVALID OPERATION — Smartsheet Community

Let us know how you go.