Invalid operation with IF Formulas

stanley.montoya

Hello Smartsheet Community,

I am struggling to figure out this IF Statement.

Smartsheet tells me this is a Invalid Operation

=IF([Use Case Development % Complete]@row = 1, "Completed", IF([Use Case Development % Complete]@row = <1, "In progress", IF([Use Case Development % Complete]@row = 0, "Not Started")))

What am I missing? This worked for another cell.

Yanis Kyr

The issue is with the = < 1. You can either use equals OR less than but not both.

On a different note, you should put the =0 argument before the <1 (the way you currently have it, the <1 will always be valid before the =0 and you will never see "Not Started").

=(IF(% complete@row = 1, "Complete", IF(% complete@row = 0, "Not started", IF(% complete@row < 1, "In Progress")))

Yanis.