Using SUMIF to provide value of orders from this week only

grant53396 ✭✭
edited 12/09/19 in Formulas and Functions


I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value.

=SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value})

The sheet references are to single columns titled 'Completion Date' and 'Order Value' respectively, but not sure what is not working as part of this?

Please could someone assist with this??


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!