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.

Automation on Row Changes at Specific Time

I want to set up an automation that runs daily at 8 am when any of three column cell values changes to any value.

I am struggling to figure out how to do this with having one email at a specific time with all the changes daily as the conditions only allow me to select cell values not change to any value and if i make the trigger rows are changed, then I can only select daily, not a specific time.

Tags:

Answers

  • Community Champion

    @swaldon2 for date/time automations, you do need to be specific about changes, is it possible to add a date column for last changed on (can also be an automation) and pick that up if it matches today-1?

    Example - Automation 1- record date when column changes. (hidden column)

    Automation 2- your date / time request if date is within the last 1 day?

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

    Always happy to work through questions or concerns!

  • ✭✭✭✭✭

    @Colleen Patterson That's a good idea. I will try that to see if it works.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions