Send email only if one of the columns contain a certain "Non"

AppSheet AppSheet Q&A
1

Hi colleagues,

I have a tabbed checklist form and I want to send email to certain people as soon as my checklist is filled only if one of my columns which are enum type contain “Non”. How to do so?

2

Hi,

You should create virtual column which concat your enum columns values; and you can use IN() function to check “Non” value.

Like This: IN(“Non”, {“Column1”, “Column2”, “Column3”})