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:
https://app.smartsheet.com/b/publish?EQBCT=4a38a139d8084d97b26d0fe1e0ac0260
Thanks as always, for the assistance! 😊
Best Answer
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Perfect! Thank you @Andrée Starå ! You have saved the day, once again!
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 60 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!