How to find first row with a checked checkbox

Mehmet

I will have two colums. First column with names, second with checkbox. checkbox column will have only one cell checked. I need to pull the corresponding name where the checkbox is checked. How can I do this?

=index(name:name, match(1,check:check)) does not work. I tried to change '1' but no luck.

Thanks

Andrée Starå

Hi @Mehmet

I hope you're well and safe!

Try something like this.

=INDEX(Name:Name, MATCH(true, Check:Check, 0))

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Mehmet

I hope you're well and safe!

Try something like this.

=INDEX(Name:Name, MATCH(true, Check:Check, 0))

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Mehmet

Hi Andree,

I am good. Thanks. Hopefully you are as well.

Using 'true' worked. Thank you very much!

Regards,

Mehmet

Andrée Starå

@Mehmet

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!