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.
Thanks
Comments
-
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
