# Formula to Trip a Flag

Options
edited 02/27/20

Hello,

I currently have a formula in my sheet that trips the Flag function in my "At Risk" Column if the due date is less than today, and the status is NOT waived. The formula below works great. However, I would like to include "PFiled" and "Efiled" to the status already referenced, but I'm stuck. Can you please assist?

=IF(AND([End Date]110 < TODAY(), NOT(Status110 = "Waived")), 1, 0)

• ✭✭✭✭✭✭
Options

Try using an OR function nested within the AND function.

=IF(AND([End Date]@row < TODAY(), OR(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)

• ✭✭✭✭✭✭
edited 02/28/20
Options

Hi Michele,

Where are the PFiled and Efiled values located?

Edit: I noticed that you mentioned status. Then Pauls formula below should work.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

Try using an OR function nested within the AND function.

=IF(AND([End Date]@row < TODAY(), OR(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)

• Options

Hi Paul -

Thanks for reaching out! I copied and pasted your formula into one of the cells in the At Risk column that had Waived and Pfiled as the Status and it didn't work. However, after tweaking it for a bit, I got it to work using this:

=IF(AND([End Date]@row < TODAY(), AND(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)

Thanks so much for your help, as you at least pointed me in the right direction.

• ✭✭✭✭✭✭
Options

Happy to help! 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!