Today IF formula not working

Hi All,

I am stumped. I have my Late or On Time column set up as a text/number column. I literally copied and pasted the formula as written from here:

And I am getting #Invalid operation? What am I doing wrong? I even put a helper date up in the grey row and changed the TODAY to that cell, same #Invalid operation operation error? Any advice?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!