Column Formula pulling from 2 Columns on 2 Sheets


  • Hi Everyone,

    I want to create this same logic from an archive sheet that has the same columns as in the second sheet. So, the first criteria does not allow the formula to run. Any Suggestions?? is it because they are the same??

    thank you for the help!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Natalia Nino Try changing the opening curly bracket inside of the red box to an opening square bracket.

    { to [

  • Hi Paul

    I changed it but still the same Error.

    =COUNTIFS({Carrier Project Range 2}, "Complete", {Carrier Project Range 3}, [Category task]@row) + COUNTIFS({Archive-Change Request Range 1}, "Complete", {Carrier Project Range 3}, [Category task]@row)

    What else do you think it could be.

    Thanks for your help

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Natalia Nino

    It looks like your second COUNTIFS is referencing two different sheets - an Archive sheet in the {first reference} but a different sheet (the same one from your first COUNTIFS) in the {second reference}, "Range 3".

    You'll want to ensure that the same sheet is being referenced within the parentheses of a COUNTIFS(__). Does that make sense?

    Try deleting out the {Carrier Project Range 3} reference from your second COUNTIFS and insert a new reference going to the Archive sheet as well.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!