Auto check box using =IF(Primary@row="California",1,0)

imtonydillard

This formula works as typed. However, I need your help writing this formula such that it will auto check box if the word is "California", or "Florida", or "Arizona".

Christina09

Hi @imtonydillard

You can add OR function to the formula:

=IF(OR(Primary@row = "California", Primary@row = "Florida", Primary@row = "Arizona"), 1)

Christina09

Hi @imtonydillard

You can add OR function to the formula:

=IF(OR(Primary@row = "California", Primary@row = "Florida", Primary@row = "Arizona"), 1)

imtonydillard

Thank you Christian Lam!

Christina09

@imtonydillard

You're welcome :) Have a nice weekend!