Adjusted Dates Based on the Time a Form is Completed

edited 12/09/19 in Smartsheet Basics

I am looking to have my automatically set due dates for projects adjust if a request is put in after a certain time of day via the Smartsheet web form.

Currently I have a date column where I add a certain number of work days to the timestamp depending on the department that submitted the request that acts as a due date for the requested action.

Our internal policy is that is anything is submitted after 10:00am, the expected lead time for the process completion should be pushed out one additional day.

I am hoping that I have missed a way to return a numerical value of the time portion of the timestamp function of the form.  This would allow for a simple IF() statement to be added to the "Due Date" column of the sheet.


Any other ideas on hoe to achieve this goal would be greatly apriciated.




  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    This formula returns the time of the the [Created] column for the current row, as text.

    =RIGHT((Created@row) + "", LEN(Created@row) - 9)

    Check for PM to get most of the day taken care of and then FIND() on the colon (:). If there it is found in the 3rd character, then you are at 10 or 11 am.

    I hope this helps.