Issues with Countif and HAS formula

Hi Smartsheets,

I am trying to understand how many projects received were made in active each month.

The column indicating the month is was made inactive has two lines of content, so the formula require a HAS @Cell. Also cross referencing a difference sheet.

The formula I am currently trying is:

=COUNTIF({other sheet referenced}, HAS (@CELL, "Jan 21"))

All I want to find out is how many projects were made in active in the month of June 2021.

Smartsheets is telling me it is 'unparseable'. Any idea why this maybe the case as the formula used is a similar one I have used throughout the sheet.

Many thanks

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @rachel Williamson

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

rachel Williamson

Hi @Bassam Khalil,

thank you for your reply, see above the screen shot of the sheet I am referencing.

First column, I am wanting to find out how many projects each month were made in active.

thank you,

Rachel

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.