Need Formula help



I need a formula in order to calculate the sum of specific hours for a resource on a particular week with a certain criteria.

For example, I need the formula that calculates the hours for Jane Doe for week ending 4/2/21 charged only to Department A. I tried something with SUMIF or IF(SUMIFS but couldn't get it to work.

Any help is greatly appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!