Determining Open Issues based on a date
Hi Community. I need to develop 2 formulas based on STATUS and LOG DATE
- Need to total request status that may be "In Progress", "Retest", "New", "Pending Closure", etc. (there is a laundry list) that have been opened based on a date. The starting date is 5/15. I need to see this total daily.
- Need to total requests where the status is "Closed" based on a date. The starting date is 5/15.
I will run the formula daily, so on 5/15 it will give me a total for each day. On 5/16 I'll run it again. I have to do this for 6 days so it won't be too bad. So maybe the Today() function will work?
Thank you for your assistance.
Best Answer
-
Hey @PMOGal
If you have a laundry list of statuses to total, one easy approach is to build a report. You would group by Status and summarize by count. You can filter on 'is today'. This would give you daily totals without any work at all. You can put the report on a dashboard, view it anytime you wish, or have it emailed to yourself (as pdf or excel) daily (if desired).
Would this work for you?
Kelly
If interested, you may find these posts helpful
Answers
-
Hey @PMOGal
If you have a laundry list of statuses to total, one easy approach is to build a report. You would group by Status and summarize by count. You can filter on 'is today'. This would give you daily totals without any work at all. You can put the report on a dashboard, view it anytime you wish, or have it emailed to yourself (as pdf or excel) daily (if desired).
Would this work for you?
Kelly
If interested, you may find these posts helpful
-
@Kelly Moore this is helpful. I will give it a whirl. Thank you for the tip and additional links.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!