How To Set Up A SUMIFS Cross Sheet Formula that Considers a Date Range.

Brendan Ginns
Brendan Ginns ✭✭✭✭
edited 06/15/22 in Formulas and Functions

Sheet 1: Entry Log

Sheet 2: Allocated Hours

Hi, I have built a formula that sums the hours from the entry log and pulls them into allocated hours. however, the cell that I am pulling the sum into is date sensitive. I am trying to build a range around the formula that takes into account the (LOG Date) and the Cell Date i.e (Week 1) (Every 7 Days ) Please let me know if someone knows how to add to this and make it a SUMIFS

=SUMIF({Entry Log Range 1}, Description@row, {Entry Log Range 2})


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!