Count if columns is not empty and the range is within the date range

Im trying to make a formula work. My logic is to count the number of cells which the projectmanagers column is not blank and the projectmanagers row is edited in the last 7 days.

This is the formula im using but it keeps returning "#INCORRECT ARGUMENT SET"

any idea on what could I be doing wrong? Any help is appreciated. Thanks!

=COUNTIFS({project managers}, <>"", {modified}, >TODAY(-7))

Find more posts tagged with

Accepted answers

All comments

John Paul Jose

This is solved now. I used a different column as reference as the project managers column is 3 columns in total with gaps and causing me problems in the formula. Thanks!

Genevieve P.

Hi @John Paul Jose

I'm glad you got this working! Thanks for posting your solution.

Cheers,

Genevieve

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.