Column Formula pulling from 2 Columns on 2 Sheets

Options

Answers

  • Natalia Nino
    Options

    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 ✭✭✭✭✭✭
    Options

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

    { to [

  • Natalia Nino
    Options

    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.
    Options

    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.

    Cheers,

    Genevieve

    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!