Calculating a due date based on date received in hours vs days

Hello!

I am intaking orders from my clients. A date, with hours and minutes, automatically records when a row is entered. I would like to set up a column for a due date that uses the same date/hours/minutes display.

Example: A row is entered and a date with hours and minutes is automatically recorded. An express order is due in four hours. I would like to be able to set a due date based on the timestamp (date/hours/minutes) that a row was entered.

I would like to be able to organize my sheet by hours vs days.

There may be a good formula for this, however, I have not seemed to find one.

Thanks for any help!!!

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Nicole Headrick

Hope you are fine, Unfortunately, this feature for time support functions is not currently available. You can submit Smartsheet Product Enhancement Requests using this form.

but you can play around, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Or if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

Nicole Headrick

@Bassam.k@mobilproject.it

Hello!

Thank you so much for checking out my question. I'll be happy to share my sheet with you. I will send you an invitation. My problem is I have turn-around times based upon hours rather than days. I have express items due in four hours, same-day items due based upon the time submitted plus five hours, 24 hours, and 48 hours.

I feel like a formula may work, however, Smartsheet does not have an easy solution. This is a MAJOR drawback for me. Any help is appreciated!!!

Thank you,

Nicole

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.