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!


  • Paul Newcome
    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.

  • 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
    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
    edited 08/03/23

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!