Check box if two cells are NOT blank

Options

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! 😊

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!