SUMIFS and Cross-Sheet Reference

Options
Misty
Misty ✭✭
edited 04/25/23 in Formulas and Functions

I am attempting to write a formula in a new sheet that sums the effort estimate for each individual by month.I feel like I'm very close as I no longer get an "unparseable" error, but my formula is returning a value of 0 when it should not. In the formula example below, I'm attempting to pull in the total of estimated hours for "Misty Lastname" for the month of January "1". Any help is appreciated!

=IFERROR(SUMIFS({Effort Estimated Column}, {Assigned To Column}, HAS({Assigned To Column}, "Misty Lastname"), {End Month Column}, "1"), "")



Best Answer

  • Misty
    Misty ✭✭
    Answer ✓
    Options

    Hi @Andrée Starå . Thank you for your suggestion. Unfortunately it did not work. The formula still returned a 0 value.

    I researched a bit more and tried using the @cell feature and was able to get it to work (hooray!!!) with this formula:

    =IFERROR(SUMIFS({Effort Estimated Column}, {Assigned To Column}, HAS(@cell, "Misty Lastname"), {End Month Column}, "1"), "")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!