Automatic Update Request

Hi everyone,

I want to set up a daily update request so my TODAY function can be refreshed everyday automatically without me having to refresh the page.

My challenge is, I don't know what my trigger should be.

Currently, we have an online form and this form is not used everyday, it could be days or even weeks in between a form submission. But I have automatic reminders set up that need to happen in between which depend on the today function being refreshed.

Thanks

Find more posts tagged with

Accepted answers

All comments

SoS | Dan Palenchar

Set up your Trigger to be "When a date is reached" ->Custom

Then select "Repeat every 1 day"

Then select the time for it to run

You could also use Zapier to populate a cell daily, or perhaps Bridge (new Smartsheet add-on) could do this as well.

Lila De Vera

Thank you @Dan Palenchar I set this up yesterday and received my request this morning. To confirm, do I need to open the email, or is the TODAY function simply refreshed by Smartsheet sending the email?

Andrée Starå

Hi @Lila De Vera

You’ll have to open the request and make a change for it to update the sheet.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.