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

Find more posts tagged with

Forms

Manufacturing

Support

Project Management

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…