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).
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives