Inspection tracking template - functions

Aly Ervin

Hello,

I am using the Inspection tracking template and it includes the following function:

=COUNTIFS({MED1}, "No", {Date}, MONTH(@cell ) = $[Month#]@row)

I would like to measure the number of violations per room, rather than per month but I am having difficulty knowing how to change the {Date}, MONTH(@cell ) = $[Month#]@row) part of the function. I would essentially like to make a function that says - count if there is a "No" within a reference, and within the row that has this lab number.

jmyzk_cloudsmart_jp

Hi @Aly Ervin

I copied the "=COUNTIFS({MED1}, "No", {Date}, MONTH(@cell ) = $[Month#]@row)" cell formulas to the rows for VIOLATIONS PER ROOM and changed the "{Date}, MONTH(@cell ) = $[Month#]@row" condition to the bold condition below.

Then, cut & paste those rows above the VIOLATIONS PER MONTH.

[B12] =COUNTIFS({MED2}, "No", {Location}, Label@row)

https://app.smartsheet.com/b/publish?EQBCT=57da5d8aaf5f4ec1bd6f9e5a08701a2f

I put the lab number in the Job Number / Location column and referenced the values as range {Location}.