Need help with this simple formula

roconnor

What am I doing wrong…..maybe the placement of the formula?? I've tried placing in the "Status" field and get a circular error…

=IF([% COMP]@row = 100, "complete", [Status]@row)

Adam Costello

It's because your formula is trying to output itself when the IF statement is false if you're putting it in the Status field. The second part of your formula needs to be a different value.

Try this:

=IF([% COMP]@row = 100, "complete", "incomplete")

Paul Newcome

If you want the other statuses to be manually updated, you would use a change cell automation to update the status to complete when the [% COMP] changes to 1.