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.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!