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
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  :(

 

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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? 

    · Share on FacebookShare on Twitter
  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    Here is how you can select a date range:

     

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

    · Share on FacebookShare on Twitter
  • John Sauber
    John Sauber ✭✭✭✭✭✭

    Rob,

     

    See my post here. Weeks 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).

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories