If multiple cells are not blank - check the box

karen_berard
karen_berard ✭✭✭
edited 12/09/19 in Formulas and Functions

I figured the formula to check a box in a column if one other column is not blank, but I can't figure out how to check the box if multiple cells within a range are not blank. I'm using this formula:

=ISBLANK([Monday | Start Time]1) = false

I have a form that feeds into a sheet that has options for meeting start time, meeting end time, reception, dinner start, etc. Currently I have it set up to notice when meeting start time is not blank, but if someone only has a reception on that day, and not a meeting, I need it to check the box.

I need something that does this:

=ISBLANK([Monday | Start Time]9:[Monday | Reception & Dinner | Location]9) = false

Thoughts?

 

SmartSheetQuestion.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!