Formula for Revenue by week and month

Im trying to determine the revenue by week and by month using the completed date field



  • in short, Helper Columns

    Create additional columns that 'see' whether a date falls between two dates, whether that is a certain week, month, quarter, or year. you can use and =IF( statement, where if it is true, then =1, if not =0


    Leverage a Sumifs statement which will add the revenue if the appropriate helper column is true, =1.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!