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
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 
Comments
-
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?
-
Here is how you can select a date range:
-
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).
