Formula for a resumed status based on 5 auxiliary status columns

FAQs
#1

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).

Question is:
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 board
image

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.

#2

The formula for each column individual result was:
IF({Sist.Eléc.}=“Correcto”,1,IF({Sist.Eléc.}=“Observado”,10,IF({Sist.Eléc.}=“Mal estado”,100,0)))

So i was assigning a value for 1 if green, 10 if yellow and 100 if its bad.
Then, in the final column if the sum of all 5 columns was 5 or lower, all status are green,
if result is higher than 6 and lower or equal than 50 there are some status yellow.
if result is more than 50 i will know that are red ones status selected.
Casting this last formula to a status will let me trigger notifications.
IF(({Col1}+{Col2}+{Col3}+{Col4}+{Col5})<=5, 1, IF(({Col1}+{Col2}+{Col3}+{Col4}+{Col5})<=50, 2, IF(({Col1}+{Col2}+{Col3}+{Col4}+{Col5})<=500, 3, 0)))

Formula works good, but general caster doesnt recognice this five auxiliary formula columns… so none result is casted…