Check for similar values in select columns (Unanimously Agreed or Not)

Thilina
Participant IV

I have an app with 4 statuses as [L1]-[L4] set by 4 different people, if they are all the same it should move to the next stage, I want to create a slice to filter rows where [L1]-[L4] does not contain the same value. What should I do for this. I am still learning the ropes with only a couple of appsheets under my belt so any help would be greatly appreciated!

0 3 145
3 REPLIES 3

Steve
Participant V

Perhaps this?

NOT(COUNT(UNIQUE(LIST([L1], [L2], [L3], [L4])))) = 1)

See also:

Hi, Thank you for the reply.
Just to clarify 1 refers to the value that will be checked to see is in all 4 columns?

The formula COUNT how many UNIQUE values are in that LIST and if all the elements are the same that means the COUNT is 1, one unique value.

Top Labels in this Space