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
Check out the Formula Handbook template!