If formula referring to checkbox columns

Pablo Carrillo

Hi Experts,

I want to insert an If formula in Column 2 that refers to a Column 3 that is restricted to checkbox options. My questions is how to refer to the values of Column 3. I have tried checked or unchecked and similar options and nothing works. Any ideas?

it would be something like =IF(Completed@row = Check, Yes, No)?

Thank you!

Andrée Starå

@Pablo Carrillo

Happy to help!

Apologies, I missed adding " ".

Try this.

=IF(Completed@row = 1, "Yes", "No")

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up 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 @Pablo Carrillo

I hope you're well and safe!

Try something like this.

=IF(Completed@row = 1, Yes, No)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Pablo Carrillo

Hi Andrée,

Thank you for your reply but that still does not not work. Any other ideas?

Best,

Pablo

Andrée Starå

@Pablo Carrillo

Happy to help!

Apologies, I missed adding " ".

Try this.

=IF(Completed@row = 1, "Yes", "No")

Did that work?

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

Pablo Carrillo

Hi Andrée,

Thank worked, thank you so much! :)

Best,

Pablo.

Andrée Starå

@Pablo Carrillo

Excellent!

You're more than welcome!

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