Formula not pulling information from reference sheet

Silvia Rangel

Hello Community,

I read a few posts trying to figure out why a formula is not working for a specific column, when its working for the rest but l was not lucky to find something like the issue l have. I am pulling metrics into a helper sheet that feeds a Dashboard and l have the same formula for all the data points l am displaying in said Dashboard. All data points are working fine but one.

It works for Site Department and Requires Follow Up? but not for Safety Tailgate - Any ideas why? this is the formula:

=COUNTIF({DER Tailgate Safety Form Tracker - Site Dept}, Category@row)

=COUNTIF({DER Tailgate Safety Form Tracker - Safety Training}, Category@row)

=COUNTIF({DER Tailgate Safety Form Tracker - Reqs Follow Up}, Category@row)

Note: there is data entered in the Safety Tailgate Training

Mike TV

@Silvia Rangel

Try this:

=COUNTIF({DER Tailgate Safety Form Tracker - Site Dept}, CONTAINS(Category@row, @cell))

Mike TV

@Silvia Rangel

Is "Safety Tailgate Training" dropdown multi-select whereas the others are single-select or just data in a cell?

Silvia Rangel

@Matt C. Yes, it's a drop-down multi-select as there are several topics that are covered during the tailgate. The others are both drop-down single-select and type in. Should an INDEX/MATCH condition should be added to the formula for each of the selections in the drop-down???

Mike TV

@Silvia Rangel

Try this:

=COUNTIF({DER Tailgate Safety Form Tracker - Site Dept}, CONTAINS(Category@row, @cell))

Silvia Rangel

@Matt C.

lt works, thanks!