Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Question about Functions and Automations

Hi - I have a formula that calculates whether or not an end date has passed by more than 7 days using the TODAY(7) function. If it is greater than 7 days, then a checkbox is checked. That checkbox is used to trigger an automation which sends a notification to a user.

My question is whether or not I have to have the sheet open for the TODAY function to work. For example if I do not open the sheet for 2 weeks, will the today function run each day anyways and add the check to the checkboxes that qualify during that time period and then trigger the automation? Or do I have to have the sheet open and active for the sheet to update?


Sam

Answers

  • Community Champion

    Hi @Sam Chan

    I hope you're well and safe!

    The sheet(s) must be "activated" to update the TODAY function.

    Please have a look at my post below with a method I developed to update the sheet(s) daily.

    More info: 

    Daily Update Solution without the need to open the sheet, use Zapier, or similar

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions