Hello, Im looking for a simple formula to count "Not started" values from a [Action Plan Status] column
This is the formula im trying to use:
=COUNT([Action Plan Status]@row, "Not started")
Thank you!
You're almost there @Rodrigo Colsa
You need to use a COUNTIF if you want to include some logic.
And to reference the entire Action Plan Status column you need to use [Action Plan Status]:[Action Plan Status] rather than [Action Plan Status]@row which just counts the single cell in the [Action Plan Status] column on that row.
=COUNTIF([Action Plan Status]:[Action Plan Status], "Not started")
thank you @KPH I was almost there!!!
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.
