Cross Referencing with IF(AND



I am simply trying to grab data from one sheet and add to another. I've done this many times before but can't seem to get this one to work. I just want to populate the first sheet below with data from the second. For example, the number for Woodland on a Monday is 68. I have tried multiple IF(AND formulas which is not working. Your help will be much appreciated.

Best Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Sam Lugiano

    Hope you are fine, please try to use SUMIFS function with Cross Referencing range to the second sheet.

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Sam Lugiano
    Sam Lugiano ✭✭✭✭✭
    Answer ✓

    I got it. Thank you. I had the references in the wrong order. Much appreciated.

    =SUMIFS({WOODLAND}, {365 Days Range 4}, "MON", {Week #}, WEEKNUMBER(TODAY()))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!