Sign in to join the conversation:
I am trying to send notifications based on multiple cell data but the default is set to "or when". I need both variables to be met before sending the notifications. I would hope this is easy and I am just not seeing it.
I'm curious what others say on this one. I thought it would be an easy one but I think you have to create and IF statement then create the alert based on the results of that formula.
Hi,
Depending on your specific use cast this can probably be set up with the help of helper columns. For example. When criteria 1 and 2 are correct a checkbox is checked, and that will trigger the rule.
Would that work?
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
