Check box if two cells are NOT blank


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:

Thanks as always, for the assistance! 😊

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!