sumif parent row

Karrie Davis
Karrie Davis Overachievers Alumni
edited 12/09/19 in Formulas and Functions

I'm looking to find the the sumif of current week for a specific matter. However the matter is only listed in the parent row

=SUMIFS({Test Hours}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Matter}, =PARENT({Matter}@row)

I keep getting an error in the formula

parent sum if_LI.jpg


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!