Automatic Update Request

Lila De Vera

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

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!