If multiple cells are not blank - check the box

karen_berard · 10/15/19

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?

Frank Falco · 10/15/19

If you are trying to find if any of them is blank then this should work:

Use @row instead of the row number, especially if you are using on multiple rows. Makes it easier for SmartSheet to calculate. I use it most of the time unless I am referencing specific cells.

You should check out

https://help.smartsheet.com/functions

and the examples sheet

https://app.smartsheet.com/sheets/fG59vPv8pw2mcCRM976JHQ2chGp85vJxW3rRv5X1?view=grid

if you are not aware of them

Paul Newcome · 10/16/19

I am not sure I follow EXACTLY what you are trying to do.

Can you explain in detail what each set of criteria is for checking the box similar to the below?

If [Monday | Start Time] is not blank

or

If the above is blank, but this cell, that cell, and a third cell (list specifics) are not blank

or

If all of the above are blank, but this 5th call is not

karen_berard · 10/16/19

Thanks Frank. This formula worked -

Although I needed the box to check if the boxes were NOT blank, so I just added a NOT infront of ISBLANK and it worked.

Thanks again.

If multiple cells are not blank - check the box

Comments

Help Article Resources

Categories