Using IF/And statements

I am running into the issue where I made a formula to flag a row if the due date is set to today or before today. But I don't know how to change it to not flag if the job has already been completed. Here is my current formula: =IF([End Date]@row <= TODAY(0), 1, 0) and here is what it is producing (below). But I don't want the flag to be there once the job is complete.


Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!