Help With Automation

Nicole J

I'm trying to create an automation (alert someone) when a specific cell in my sheet is greater than or equal to $1,500.

Right now, when I try to create an automation, my only available triggers are:

When a date is reached
When rows are added or changed
When rows are changed
When rows are added

I need a trigger for "When a cell changes" (specific cell, not any cell in that row).

Thoughts/Ideas?

Thanks.

Find more posts tagged with

Automations

Accepted answers

Melissa Yamada

Hello @Nicole J,

How about creating a helper column that will return the value of the specific cell then use the:

When rows are changed and when helper column changes to $1,500. You can also add a condition where helper column is not blank so it will only look at the cell where there is value.

All comments

Melissa Yamada

Hello @Nicole J,

How about creating a helper column that will return the value of the specific cell then use the:

When rows are changed and when helper column changes to $1,500. You can also add a condition where helper column is not blank so it will only look at the cell where there is value.

Nicole J

I'm getting where you're going with this. Thanks, Melissa. I think I can manage from here. Many, many thanks.

Melissa Yamada

Happy to help 😊

Humashankar

Great Insight

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.