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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!