why is my cell saying #UNPARSEABLE

756wire.Electric

=IF([Received By:]@row]="A";1,0)

I know my formula is incorrect, but I am not sure where.

I am trying to automatically check the box if the column "Received By:" has a value.

DKazatsky2

Hi @756wire.Electric ,

Try this.

=IF(OR([Received By:]@row = "A", [Received By:]@row = "M", [Received By:]@row = "K"), true, false)

Note: I am assuming you are looking for only one of those values.

Hope this helps,

Dave

Andrée Starå

Hi @756wire.Electric

I hope you're well and safe!

Try something like this.

=IF([Received By:]@row="A";1,0)

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

756wire.Electric

I actually got it work with this formula "=IF([Received By:]@row = "A", true, false)"

But now I am wondering how to add more options, I would think something like this "=IF([Received By:]@row = "A", "M", "K" true, false)"

but that is not working. Do you have anything else to try?

DKazatsky2

Hi @756wire.Electric ,

Try this.

=IF(OR([Received By:]@row = "A", [Received By:]@row = "M", [Received By:]@row = "K"), true, false)

Note: I am assuming you are looking for only one of those values.

Hope this helps,

Dave

756wire.Electric

That worked! Thank you so much.