I'm trying to find the count if a list of col...

(Ivan Oboth) #1

I’m trying to find the count if a list of columns values for a record equals a certain text value (“X”). The list formula would be as below. LIST([Column1], [Column2], [Column3], [Column4]).

Is there a way to count if any column in this list = “X” without having to do an IFS for each column value?

(Praveen Seshadri (AppSheet)) #2

IN(“X”, LIST([Col1], [Col2], … ))

(Ivan Oboth) #3

Thank you @praveen