How to get first item in list of names that doesn't have a checkbox next to it

1

I have a table with names in 1 column and a checkbox in 2nd column

I simply want the first name in the table that doesn’t have a ticked checkbox. Sorry if this is so easy but I’m having a struggle getting the right function using filtering on the checkbox and the first() function.

-Peter

2

[Table 1].Filter(Checked.Not()).Name.First() should give you the name. Checked is the name of checkbox column and Name is the column with names.

1 Like
3

Yes it worked - thanks so much!