Help on Formula using 'WEEKNUMBER'

Hi all, Hope everyone is doing well? Hoping someone could help on using formula on ‘WEEKNUMBER’ from my below table (this is just a few transactions for an example) but the original table consists of large volume of transactions, I wanted to count totals of transactions on weekly basis from this table (eventually on to a different sheet). Tried using ‘WEEKNUMBER’ formula but cannot get it work.

Much appreciate if someone here could help me on this if there is a way? Many Thanks in advance!

I used below formula but i keep getting result as ‘0’

=SUMIF([Sold Date]:[Sold Date], WEEKNUMBER(TODAY() = "2", [Transaction

Total]:[Transaction Total]))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!