Formula based on System-Generated Created Time

Is there are formula to bring the time out of the the System-Generated Created Time to e.g. add on 20 min to this and then perform an action?

I have an easy sheet which is filled via 2 forms; one form is used to check in, one is for the check out, filling the same sheet.

Problem statement: If someone forgot to check out, we want to have an automation after 20 min, that this checked in person is automatically checked out or alternatively gets an email that he/she has to check out.

I researched a lot here in the help articles but did not find much for now, any help is appreciated!

Thanks!

Find more posts tagged with

Formulas

Accepted answers

L_123

No, you cannot check current time directly with a formula inside of smartsheet. If you want to add 20 minutes to the time that is possible through text parsing, but the alert can't be set up through standard smartsheet functionality.

That said this could be completed through the API, but it would require coding.

All comments

L_123

That said this could be completed through the API, but it would require coding.

Mony Eibner

Hi, thanks a lot for the fast reply. I already assumed that it will not work but wanted a verification. Unfortunately coding is not an option. But thanks again, I will tell the owners that they have to monitor their sheet manually and check out people directly there if they do not check out themselves.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.