Cross-sheet formulas


Hi Community!

How are you?

I'd like to have the result of the following formula in another sheet:

=SUMIFS(Hours:Hours, Date:Date, >=DATE(2023, 2, 5), Date:Date, <=DATE(2023, 2, 11), Done:Done, 1)

I tried the following way but it did not work:

=SUMIFS({Hours0}:{Hours0}, {Date0}:{Date0}, >={Date0}(2023, 2, 5), {Date0}:{Date0}, >={Date0}(2023, 2, 11), {Done0}:{Done0},1)

What is wrong? Thank you so much!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!