nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

=COUNTIFS Specific Dates

adrian.bleivns112656

I am trying to count the number of times a specific schedule date is listed in a column for a sheet, not able to narrow down the formula exactly

Find more posts tagged with

Comments

adrian.bleivns112656

I tried the following with no luck - =COUNTIFS({MEDCTR-1 Range 1}, "12/02/19"). All I get back is a value of 0 even though I have 64 cells that meet that criteria

Paul Newcome

When referencing dates in a formula, you need to use the DATE function.

=DATE(yyyy, mm, dd)

=COUNTIFS({MEDCTR-1 Range 1}, @cell = DATE(2019, 12, 02))

Sign in to join the conversation!

Quick Links

Trending discussions

Run Generate Document Workflow On Multiple Rows
Hello everyone, I have several rows (different entries) that I would like to enter on a custom form using the "Generate Document" workflow. I did a test run and it just generated "individual" PDF form per row - and not multiple rows merged into one form as I was expected. Is there another way or methodology around this or…
Sharing a Single Smartsheet with External Partners (No SSO Access)
Hi Smartsheet Community, I’m hoping you can help clarify a Smartsheet sharing question. I’m trying to share one specific sheet from my Smartsheet plan with two external colleagues from our partner organization. Several colleagues have mentioned they’ve successfully shared sheets with external partners before, so I’m hoping…
Form Creation
Is it possible to create a form on sheet 1 with information from sheet 2? On Sheet 1, I'm tracking what we ship and receive. On Sheet 2, I'm tracking the shipping requirements. I want to pull data from this sheet for a shipping request form on sheet 1.