Check box if two cells are NOT blank

Nancy Heater

Hello Smartsheet Community!!!

We need to check a box based on two other cells not being blank. We have tried to reverse engineer checking the box when cells are blank, but we just can't get it to work. Any help would be greatly appreciated.

Column Cells that need to be populated: SHIP DATE + SHIP TRACKING

Required Result: Check box in "SHIPPED" column to be "checked" if the above column cells are both populated with data (i.e. not blank).

Link to our test sheet is below:

https://app.smartsheet.com/b/publish?EQBCT=4a38a139d8084d97b26d0fe1e0ac0260

Thanks as always, for the assistance! 😊

Andrée Starå

Hi @Nancy Heater

I hope you're well and safe!

Try something like this. (added to your sheet)

=IF(AND([SHIP DATE]@row <> "", [SHIP TRACKING]@row <> ""), 1)

Did that work as expected?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Andrée Starå

Hi @Nancy Heater

I hope you're well and safe!

Try something like this. (added to your sheet)

=IF(AND([SHIP DATE]@row <> "", [SHIP TRACKING]@row <> ""), 1)

Did that work as expected?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Nancy Heater

Perfect! Thank you @Andrée Starå ! You have saved the day, once again!

Andrée Starå

@Nancy Heater

Excellent!

I'm always happy to help!