Flag Formula


I would like to make the flag red if 2 criteria are met % Column is under 80% AND Deadline is within the next 2 days?

IF(AND(% Column)@row), <80%, (Deadline)?

I'm stuck on the second half of the formula can anyone help?

Many thanks


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!