Specific date placed in date range



I am trying to do a sumifs and one of my conditions is based on date. My reference sheet has specific dates (Ex. 12/19/23) but my new sheet has date ranges by week (Ex. 12/18/23-12/24/23).

How can I pull the data with the specific date and place that data within my date range on the new sheet?

Thank you.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    There's the issue. You have text strings that only look like dates. Try adding in two more helper rows (for a total of three) so that you have one for the year, one for the month, and one for the day. Then you can adjust your SUMIFS like so:

    =IF(SUMIFS({Copy of Recon Sheet - Active Range 2}, {BCA}, $BCA@row, {Date}, DATE([Wk 45 11/6]3, [Wk 45 11/6]4, [Wk 45 11/6]5) <= @cell, ...............


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!