Puzzle and Possible Formula Solution Inquiry?

I need to create a formula to pull information from a Smartsheet to another with two different columns. For example:

Year Criteria Geography

2023 Yellow North

2022 Orange East

Let's say there are 50 entries that meet these criteria. I need a formula that will pull all 2023 Yellow North data to another Smartsheet. Then, pull all 2022 Orange East data.

I am running into a situation where the "Countif" functionality is only counting in one category.

Has anyone run across this situation in Smartsheet? If so, how did you resolve it? Thanks!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you trying to pull multiple rows over or generate a count? If the COUNTIF is not providing the flexibility or detail you need because it only allows for a single range/criteria set, try the COUNTIFS function which allows for multiple range/criteria sets to be included.

Electricguy

I need to reference three columns into a single count. Using the example above, 2023 Yellow North - 50, 2022 Orange East - 50,..etc.

The Countifs function is giving me issues since the columns are not located next to each other. Now, I need to copy a Smartsheet, hide the unnecessary columns, then...I can't figure out the formula without getting an unparseable error.

Paul Newcome

They don't have to be next to each other. You just reference them one at a time.

=COUNTIFS([Column A]:[Column A], @cell = "This", [Column B]:[Column B], @cell = "That")

Electricguy

Don't I need to put the report in the formula to pull from that sheet?

For example: =Countifs({Report Name}),[Column A]:[Company A],"Color",[Year]:[Year],"2021"

Does that formula make sense? I keep getting an unparsable error so I'm doing something wrong here...

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.