Calculating a column based on date

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

I'm trying to total up the job value column based on weekly totals. Can I have the formula calculate the weeknumber or do I have to create a helper column?

Screen Shot 2019-08-13 at 9.14.53 AM.png

Screen Shot 2019-08-13 at 9.14.09 AM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!