I have a Google Sheet that sends an alert if ANY of the ROW/COLS are changed or added. I send a Gmail alert to let a user know that there has been a change on Row(X).
However I am trying to add a condition so that if the Zap is triggered only to send an email if that value changes below a threshold - here 55%
When applying a conditional filter it is asking me for a specific col to watch, in this instance I need it to watch the whole sheet.
Any ideas anyone? I’m on a Premium Starter Plan.
Best answer by ForYourITView original