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!
Answers

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.

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.

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")

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...
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!