Invalid operation with IF Formulas

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.


Tags:

Answers

  • Yanis Kyr
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!