Count rows based on Date and Value criteria

Hi,

I'm trying to count the rows in a sheet that have two criteria. I'm using the formula in a Sheet Summary field. The Date Initiated column cannot be blank and the Risk column is at High. Here is the formula I've tried with some variation:

=COUNTIFS(Rating:Rating, "High", [Date Initiated]:[Date Initiated], ISDATE@row)

All I get back are normal formula errors.

Find more posts tagged with

Accepted answers

All comments

Michael Pappas

If you want to use the ISDATE function, then (according to this https://community.smartsheet.com/discussion/35316/countifs-problems#comment-114691) your formula should be =COUNTIFS(Rating:Rating, "High", [Date Initiated]:[Date Initiated], ISDATE(@cell)).

Alternatively, you could just look for not-blanks in your Date Initiated column like this: =COUNTIFS(Rating:Rating, "High", [Date Initiated]:[Date Initiated], <>"").

Scott Peloquin

I tried both and and all I get is #Invalid Operation. The date column is formatted as a date type but the Risk column is a formula to display high, medium, or low based off a calculated value in another column. The Risk column is not a singe select data type. Not sure if that's what is throwing this off.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.