Adjusted Dates Based on the Time a Form is Completed

mattmelheim

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.

 

Thanks

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.

Craig