Adding IF condition Formula

Good morning,

I'm struggling with the syntax for the following formula where I'm trying to include a WHERE condition that looks for an active status. The formula works great until I introduce the WHERE condition to the point I've just thrown my hands up. My status flag condition is either 'Active' or 'Not Active', or 'Open'.

=COUNT(DISTINCT(COLLECT({FY Forecasts Resource Name}, {FY Forecasts Product Team}, "xxx")))

I've adjusted it to the following:

=IF({FY Forecasts Resource Status}, "Active", COUNT(DISTINCT(COLLECT({FY Forecasts Resource Name}, {FY Forecasts Product Team}, "xxxx"))))

The results are an 'Invalid Data Type'.

This should be simple but I've managed to not get it done. Any help would be appreciated.

Jason

Find more posts tagged with

Formulas

Accepted answers

All comments

Jason Voorhies

Marisol

=COUNT(DISTINCT(COLLECT({FY Forecasts Resource Name}, {FY Forecasts Product Team}, "xxx", {FY Forecasts Status}, "Active", {FY Forecasts Status}, "Not Active", {FY Forecasts Status}, "Open"))) how about this?

Jason Voorhies

@Marisol YES with one exception…if I include anything other than 'Active' it returns a 0. I don't want it to count 'Not Active' only 'Active' and 'Open'. It is functional, but I'd like to be able to include 'Open' as part of the count when applicable.

Marisol

check the spelling on your sheet you may have a space somewhere.

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