Smartsheet marking items late -

Hi (Paul, if you are listening!) I have a formula that determines if an application is on time or late -

It is marking applications that come in on the same day as the Final Filing Date as LATE (i.e., received date = 4/20/21 10 am, FFD 4/20/21 = LATE - however, these should be considered on time as the formula is saying the received date must be GREATER THAN the FFD or Ext FFD not = or greater... I'm at a loss how to fix this - I've created an "adj date - ss" column to fix any that are marked late, but what a PAIN... please let me know what I may be doing wrong! Thank you

=IFERROR(IF(OR([APPLICANT/CANDIDATE NAME]@row = "ADVERTISEMENT", [Adj Date - ss]@row <> ""), "", IF([RECEIVED DATE]@row > MAX([EXTENDED/READVERTISED FINAL FILING DATE]@row, [FINAL FILING DATE]@row), "Late")), "")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!