Create a formula using the outcome of another formula in a different column

Yars

Basically, I want to know all the Issues for the 4 stars groups.

Im using this formula to count the multiple values in a column - =COUNTM([Issue]:[Issue])

But I want to say, all Colorado groups have (this amount of

Smartesheet.png

issues) which is the result of the previous formula.

Find more posts tagged with

Formulas

Accepted answers

All comments

Yars

I'm trying this but it is not working

=IF(State:State, "Colorado", COUNT([Issue]#))

Zachary Hall

If I understand you correctly, I believe this should do it:

=COUNTIF(State:State, "Colorado")

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.