Automation

Karrie Davis

Karrie Davis Overachievers Alumni

03/09/21 in Formulas and Functions

Hi I want to set up an automation that sends an alert on Wednesdays at 9am is there a way to set this up. I thought there was an option however, I'm not seing it.

Tags:

Automations

0 ·

Answers

Mike Wilday Community Champion

03/09/21

Just change your trigger to "When a date is reached" and you can set up recurring reminders there. '

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula is #unparseable and not cleat why, help?
=IFERROR(AVG(COLLECT({Score BA}, {Employee Email BA}, $Variable@row, {Date of Review BA}, ISDATE(@cell), {Date of Review BA}, YEAR(@cell) = $[Last Year]$102, {Date of Review BA}, MONTH(@cell) = [Last Year Feb]102), COLLECT({Archive Score}, {Archive Employee email}, $Variable@row, {Archive date of review}, ISDATE(@cell),…
How to use index collect?
Hi, I'm trying to write a formula that will look at a particular column (in this case the "extrusion" column) and return the first entry that has a check in the "cycle count is due column". My current formula is below and comes up unparseable. =INDEX(COLLECT({Metal- Shop Floor Inventory Range 1}, {Metal- Shop Floor…
Formular Stripped from cell when the row moved into different sheet
Hello, I use simple formular to assign Due date =WORKDAY (Start Date, #of days) to add. I love it- Simply Works! Attached image. Now, when this row met workflow automation criteria, and then move into different sheet as completed, the formular no longer display. Only show Due date value. It this stripping formula normal? I…