Countif within a If calculation

Hi,

I'm new to Smartsheet and I'm trying to get a calculation working, which I cannot seem to work out what I'm doing wrong

There is an issue with Countifs in the False option, however, if I put just this calculation it in a separate cell it works fine. the error I get is #INVALID OPERATION.

=IF(COUNTIFS({Date}, HAS(@cell, M$1), {Team Member}, HAS(@cell, $[Primary Column]@row), {Project Type}, HAS(@cell, "Confirmed")) >= 1, "-1", =COUNTIFS({Date}, HAS(@cell, M$1), {Team Member}, HAS(@cell, $[Primary Column]@row), {Project Type}, HAS(@cell, "Internal")))

any help greatly received

Many Thanks

Barry

"I have found the issue the = and the start of the second countifs is not required

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Here's the corrected version of your formula without the unnecessary equals sign:

=IF(COUNTIFS({Date}, HAS(@cell, M$1), {Team Member}, HAS(@cell, $[Primary Column]@row),
 {Project Type}, HAS(@cell, "Confirmed")) >= 1, "-1", COUNTIFS({Date}, HAS(@cell, M$1),
 {Team Member}, HAS(@cell, $[Primary Column]@row), {Project Type}, HAS(@cell, "Internal")))

Barry.davies

Thanks Bassam

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.