Late Submission formula

Lisbeth Fuentes-Fernandez

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!

Tim Shaded

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.

Tim Shaded

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.

Lisbeth Fuentes-Fernandez

Thank you so so much, Tim!!

This is exactly what I needed! :)