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