Hello ! I’m trying Appsheet since a week and I ask myself a big question in format rules (that I didn’t find answer anywhere, or clear answer at least). Is it possible to make a condition that will check every column ? I will explain myself :
I have lots of Enum column that have the same answer (“Valid” and “Not Valid”) and I would like to create 1 Format Rule that will put each “Valid” in green and 1 Format Rule that will put each “Not Valid” in red. But the problem is that because they are different columns I fear that I must make each time 2 Format Rules for 1 column.
(TL:DR : Condition is not a single column and I don’t want to put everything in one color if only one Enum is “Valid” or “Not Valid”)
I know that a YES/NO could do the job, but I would prefer a more personal view. Thank you for your answers and your time