How do I set up a notification for a specific row that contains formulas

KCS · 09/30/20

I have a row that consists of formulas that are changed by other rows. How do I:

Set up a notification for just one row (not column)?
Set up the trigger to recognize when the product of the formula has changed? (i.e. if the formula in a column adds up to 150 this week and next week it changes to 200, that is a change that I need to know about - and the row consists of about a dozen formulas.)

Thank you

Andrée Starå · 10/01/20

When you set up the Workflow, you can select a condition (something unique about the row), and also, you’d choose that it should only Alert when the value changes.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or 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!

KCS · 10/01/20

Hi Andree

Thanks for responding. I'm having trouble setting the condition. This is what I've done so far:

Trigger = When rows are changed

1. When = Any field changes

2. Run workflow = When triggered

Conditions

3. Where = Total January (I guess I would have to do a condition for every month?)

4. ***This is where I get stuck. There is nothing that says when this cell changes. How do I choose a row instead of a column?

Thanks

~KC

Andrée Starå · 10/08/20

@KCS

Happy to help!

You'd need to add another condition.

For example, it can be the task name of the specific row with the cell.

Make sense?

How do I set up a notification for a specific row that contains formulas

Answers

Help Article Resources

Categories