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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!