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 Based on Number Formula

I have a Number column with a formula as below, where the number keeps changing ( where [column] is a date column )

=TODAY()-[column]@row

I want to send reminder alerts and update requests automatically as the number keeps changing ( say 1, 5, 10, ... ).

Will this be caught in a Automation Trigger such as Row Changed (without user changing any row fields) ?

ps: I'm reading and evaluating.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions