Distinct Count of 4th Field Added to Formula Pulling 3 Fields

I need a distinct count of a fourth field added to this formula which is a combination of pulling three fields:

=COUNTIFS([Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)

With the three three fields being: Price Sheet Deadline (by month), Price Sheet Status, and if account was renewed=yes.

And I want to add a distinct count of a fourth field called Price Sheets. How would I fit this into the above formula? I tried this but it didn't work:

=COUNTIFS(DISTINCT(COLLECT([Price Sheet]:[Price Sheet},[Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1))

Find more posts tagged with

Accepted answers

Leibel S

@Carrie Tortorella

=COUNT(DISTINCT(COLLECT([Price Sheet]:[Price Sheet],[Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)))

Leibel S

@Carrie Tortorella

do you have a column [price sheet] in your sheet?

All comments

Bassam Khalil

Hi @Carrie Tortorella

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.

Leibel S

@Carrie Tortorella

Leibel S

https://community.smartsheet.com/discussion/comment/297061#Comment_297061

See below I added an @cell reference. Should fix it.

=COUNT(DISTINCT(COLLECT([Price Sheet]:[Price Sheet], [Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], @cell = "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)))

Carrie Tortorella

Hi @Leibel S this formula was also unparseable. It appears the same as the first one pasted too. Are you sure it was changed?

Leibel S

@Carrie Tortorella

do you have a column [price sheet] in your sheet?

Carrie Tortorella

@Leibel S Please forgive me I edited and it worked. Thank you so much!

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.