If multiple cells are not blank - check the box

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?

Find more posts tagged with

Healthcare

Formulas

Accepted answers

All comments

Frank Falco

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

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

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

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

karen_berard

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.