Late Submission formula

Hi All!!


I am hoping to create a formula to alert me when a request was submitted late.

For example - if a request was submitted on 10/1/21 and the request is to start 12/1/21, then the request would be marked as a late submission as the request was submitted within the 60-day deadline we set.

I do want a column that would be pre-filled to say "LATE"

Can anyone help with this?

Im new to smartsheets and i am completely uneducated on formulas! lol.


Thank you!

Best Answer

  • Tim Shaded
    Tim Shaded ✭✭✭✭
    Answer ✓

    You could try something as simple as this:

    =IF([Start Date]@row - [Submitted Date]@row < 60, "LATE", "OK")

    The "Submitted Date" column can be auto populated when set as Auto-Number/System column for "Created (Date)". This would ensure the accuracy of submitted date.

    Hope this helps.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!