Cross Referencing with IF(AND

Options
Sam Lugiano
Sam Lugiano ✭✭✭✭✭
in Formulas and Functions

Hi,

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.

image.png
image.png


· Share on FacebookShare on Twitter

Best Answers

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

    Hi @Sam Lugiano

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

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

    · Share on FacebookShare on Twitter
  • Sam Lugiano
    Sam Lugiano ✭✭✭✭✭
    Answer ✓
    Options

    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()))

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!