Checking if a box is checked.

Doyle54

In general and specifically, how do you check if a symbol is in a cell, like a check mark? I am setting up a formula that checks if a well site has been inspected denoted by a check mark in a cell for a pad row.

Andrée Starå

Hi @Doyle54

Not sure I follow!

Try something like this.

=IF(Checkbox@row = 1, "Checkbox is checked")

Was that what you meant?

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

Andrée Starå

Hi @Doyle54

Not sure I follow!

Try something like this.

=IF(Checkbox@row = 1, "Checkbox is checked")

Was that what you meant?

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

Doyle54

Yes. So, it is a numeric 0 or 1. Thank you. Best as Always

Andrée Starå

@Doyle54

Excellent!

I'm always happy to help!

Doyle54

Andree - I figured out a method that works for me but it would have taken me 5X🤔 😉the time to figure this out if you did not provide your comments and advice. As always, Thank you So Much and Have a Great Day and Month!

🤗

Carey

Andrée Starå

@Doyle54

Excellent!

As always, you're more than welcome!

Have a fantastic week!