Inspection tracking template - functions

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.

Find more posts tagged with

Formulas

functionality

Sheet Summary

Accepted answers

All comments

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}.

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.