SUMIFS or SUM(COLLECT) With Cross-sheet Reference

I'm trying to total up hours from a timesheet for each individual across multiple projects. I've tried the following two formulas but both are returning 0.

SUMIFS({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row)

=SUM(COLLECT({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!