IS THERE A WAY TO GROUP PER WEEK?
I am trying to group per week on a report so like it would say " week of mm/dd/yy - mm/dd/yy" or just "mm/dd/yy = mm/dd/yy"
Answers
-
You can create a helper column with that text in there. I assume your column has a date in it, you will need to use a formula to determine which week that date belongs in. You can calculate that on the fly by taking the date, figuring out the date of the previous Sunday and the date of the next Saturday, or you can create a lookup table with every date in it going out years into the future (and past I suppose) and then looking up the range when a date is entered.
Do you need help with that formula? There are a lot of threads that explain how to do that. For example:
Display the prior "Monday" date from the following week — Smartsheet Community
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives