Report for completion dates with in 7 days and within 30 days
I need to somehow show what projects within a sheet were completed within 7 days and what has been completed in 8-30 days
Show each project title that was complete - or show a QTY of projects that were complete in those days. Either would be great!
How do I pull this data to create a widget or something of the sort?
I've tried numerous functions etc - not able to get the formula correct
Answers
-
Hi @carly
I actually think the easiest thing to do here would be to create a Row Report!
You can make two Reports, with two different filters based on that Date Column. See: Create Filter Criteria to Control Data in Report Builder
Then if you're on a Business or Enterprise plan, you could use the Summarize function at the top of the Report to quickly COUNT how many rows are associated with your filter. See: Redesigned Reports with Grouping and Summary Functions
If you want to display this using a chart, you'll need to both Group and Summarize. The way I would do this is Group by the Sheet Name (meaning all rows will be in the same Group) then Summarize. The Report will then have 2 rows at the top with your data, which will then allow a Chart to use this as a source (as it skips over the top-summary row).
Let me know if this makes sense or if you'd like to see more screen capture examples!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!