Comparing names from Worksheet A to Worksheet B and Identifying those on A that are missing from B

I have two worksheets.
Worksheet A is the master
Worksheet B is a collection of months' worth of data-it is populated by a form.
I'm trying to write a formula where I compare Names from Worksheet A to Worksheet B and identify on Worksheet A names that are missing from B in the current month.

Worksheet B has a column that identifies a row as current month.

=IF(COUNTIF({TOD Monthly Fleet Vehicle Safety Inspectio-ePlan #}, [ePlan #]@row ) = 0, "Missing")

The above formula identifies names on Worksheet A that are missing from Worksheet B, but how do I add in current month criteria to the formula?

Find more posts tagged with

Formulas

Accepted answers

All comments

Carson Penticuff

I'm making a few assumptions here, such as the column in Sheet B that identifies the current month being a checkbox, but this is the general idea:

=IF(COUNTIFS({TOD Monthly Fleet Vehicle Safety Inspectio-ePlan #}, [ePlan #]@row , {Sheet B - Current Month}, 1) = 0, "Missing", "")

You will also need to replace {Sheet B - Current Month} with whatever you choose to name the cross sheet reference to Sheet B that links the "Current Month" row.

The COUNTIFS() function is what makes this possible:

https://help.smartsheet.com/function/countifs

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.