Automation Based on Number Formula

Riyaz Mansoor

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.

Find more posts tagged with

Automations

Accepted answers

All comments

Andrée Starå

Hi Riyaz,

Yes, as long as the sheet is activated in some way, so the TODAY function updates the rows.

Would that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.