Formula to Trip a Flag



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)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!