Sum numbers in a column based on week ending filed -5 days

TLaGrant ✭✭
edited 01/09/23 in Formulas and Functions

I have a Column called Total Overtime Hours and a a column called week ending which has a date in it. I am trying to sum all the overtime hours by the week ending - 7days I'm doing this calculation in the sheet summary tab.

Here is what I have been trying to get to work

=SUMIF([Total OT Hours]:[Total OT Hours], ([Week ending]), <=TODAY(-5))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!