Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Calculations in a report

Rob van Dijk
edited 12/09/19 in Archived 2015 Posts

I'm trying to create a report where i only see records with End Date = this week.  

(so not 'the coming 7 days' or something, only this week#)


I have column 'Week# that shows the week# of the field 'End Date' in my sheet

  =ROUND((([End Date]1 - DATE(2015, 1, 1)) / 7) + 0.49, 0)


in my report I defined in the 'What' part:

  [Week#] is equal to [=ROUND(((today() - DATE(2015, 1, 1)) / 7) + 0.49, 0)]


(so if today is week number 32, i only expected rows with an End Date in the current week)


no result  :(




  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Surely you can use the Date filter in the Report to either select dates relevant to whenever "today" is ie + or minus 7 days. Or if you are seeking a report that selects a specific date range then that is available too. It doesnt need to be very complex? 

    Hope that helps, not sure by seeking a week number you are helping things? 

  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    Here is how you can select a date range:


    Screen Shot 2015-08-13 at 11.26.08 AM.png

  • John Sauber
    John Sauber ✭✭✭✭✭✭



    See my post hereWeeks to Start can easily be turned into Weeks to Complete. You can then filter and report against this numerical field till the cows come home!


    I think you're specifically looking to filter where this column is less than 2 (this will allow you to include upcoming and overdue tasks as well).

This discussion has been closed.