I have a board for daily checking of our vehicle fleet. We have 5 status columns that are filled via forms with these possible values: Good- With observations - Bad
I need to notify the vehicle boss when something is bad or observed, but i dont want the boss to be notified by every status column (if 5 status are observed or bad, the boss will be receiving 5 notifications, 5 emails etc). I need to get a “result” in a form of a status or a text column (anything).
what columns or apps (like general caster) to use with formulas, to get just 1 (one) notification for each form everytime that one or many statuses are observed (yellow) or bad (red).
My workaround failed, because i planned to use one formula column for each status and with a final formula column get this resume status. With this formula result, i was planning to cast via “general caster” app the result to a status, and trigger the notification.
Problem is general caster work with formulas, but not with formulas that already calculates with other formulas inside), so these is not viable.