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.

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.

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