I'm trying to get a formula to read when something is late.

I have the following columns,

ETA field that has a date.

# Received

so I want to say if # received is blank and eta is <= to today() then say "Late".

I've tried multiple versions of if, if and, blank...etc and can't get it to work. I am not working with dependancies.

Any help is appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!