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

imtonydillard ✭✭

10/29/21 in Formulas and Functions

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".

Tags:

• Formulas

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Best Answer

• 

  Christina09 Community Champion

  10/29/21 Answer ✓

  Hi @imtonydillard

  You can add OR function to the formula:

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

  1 · Share on FacebookShare on Twitter

Answers

• 

  Christina09 Community Champion

  10/29/21 Answer ✓

  Hi @imtonydillard

  You can add OR function to the formula:

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

  1 · Share on FacebookShare on Twitter
• 

  imtonydillard ✭✭

  10/29/21

  

  Thank you Christian Lam!

  1 · Share on FacebookShare on Twitter
• 

  Christina09 Community Champion

  10/29/21

  @imtonydillard

  You're welcome :) Have a nice weekend!

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list