Trying to trigger a flag to turn red once the project status column has changed

dmorettin

Have a Flag column named Outstanding Balance. I would like to have the flag trigger red if the project status column (which is a drop down) is changed to Invoiced or partial payment received.

I have tried various formulas, but it keeps coming up with #unparseable.

Any help would be appreciated.

Thanks

Paul Newcome

Try this:

=IF(AND(Awarded@row = "Yes", [Project Status]@row <> "100% Paid - Good to Close"), 1)

DKazatsky2

Hi @dmorettin ,

Try this. =IF(OR([Project Status]@row = "Invoiced", [Project Status]@row = "Partial Payment Received"), 1)

Hope this helps,

Dave

dmorettin

I have tried this one already and could not get it to work.

If there is conditional formating that changes the entire row to a color, would this affect the formula?

Thanks,

David

Shubham

Hi dmorettin, 

Please try the following formula - 

=IF(OR([Project Status]@row = "Invoiced", [Project Status]@row = "Partial Payment Received"), 1, 0) 

 Thank you,

Shubham Umale

Associate - Smartsheet, Ignatiuz Software

dmorettin

Thank you that worked.

Now they want to change it. They want the flag triggered on "red" when the Awarded column drop down is changed to "yes" and then triggered to off "not red" when the Project Status column drop down is changed to "100% Paid - Good to Close"

Paul Newcome

Try this:

=IF(AND(Awarded@row = "Yes", [Project Status]@row <> "100% Paid - Good to Close"), 1)

dmorettin

Hi Paul,

That worked great.

Thank you!

Paul Newcome

Happy to help. 👍️

Paul Newcome

@HarryS You should be able to just use a Conditional Formatting rule for this.