Formula to return a number of values that have entered in the last X amount of days

I'm looking for formula help to get me to an end point on a dashboard that would look something like this… Not sure if a report or metric sheet would be best way to get to this point (I prefer a metric sheet if possible)

I have a sheet that is collecting the names of these units as well as the date the info was submitted. Really just want the number of things that people submitted that were in the last 7 days and last 14 days or just counting that they have submitted something during these time frames if that makes sense?

Would really appreciate formula help or any ideas on how this could be displayed. I'd assume I would use my unit column and date column. Thanks.

Find more posts tagged with

Formulas

Dashboards

Accepted answers

Paul Newcome

If you have the unit names in rows in your metrics sheet, your COUNTIF Swould be along the lines of:

=COUNTIFS({Unit Column}, @cell = Unit@row, {Date Column}, AND(@cell >= TODAY(-7), @cell <= TODAY()))

All comments

Ty Werven

It would be awesome if I could use something like this but use an @row function with my 'Unit Names' in rows.

Paul Newcome

If you have the unit names in rows in your metrics sheet, your COUNTIF Swould be along the lines of:

=COUNTIFS({Unit Column}, @cell = Unit@row, {Date Column}, AND(@cell >= TODAY(-7), @cell <= TODAY()))

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.