Can OR function be used with cross-sheet references?

I'm trying to use OR with SUMIFS in a cross-sheet calculation but it doesn't work. As an example the formula below yields a INVALID OPERATION error.

=SUMIFS({TotalCost}, {Cost Center}, [Cost Center]@row, OR({Reason} = "Other", {Reason} = "Training"), {Region}, "Domestic", {Approved}, 1, {Year}, "2020")

Thanks,

TY

Best Answer

Answers

  • Ty Hickman
    Ty Hickman ✭✭✭

    Bingo! It worked. Thanks for the lesson Genevieve. This community is really useful.

  • Genevieve P.
    Genevieve P. Employee Admin

    Wonderful! So glad that worked for you, and happy to help. :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!