Adjusted Dates Based on the Time a Form is Completed
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.