Column Formula pulling from 2 Columns on 2 Sheets



  • Natalia Nino

    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 [

  • Natalia Nino

    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.

    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.



    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!