How to reflect the patient load correctly for a provider in the report.
Answers
-
@Ken Armstrong Hi Ken, Hope you are doing great. I have a question connected to my old question. Your formula is working perfectly, but now the requirement changed, and I'm not sure how to solve it.
The scenario is We have providers who visit patients living at different facilities. Some patients pay extra to be seen twice a week, and one provider will visit the same Patient twice a week. This is where your formula helped.
If you see my screenshot posted above, you helped me calculate how many patients are seen by a provider and what is the total number of times a provider is visiting them.
I pulled this info by using a report (please see the screenshot below), and now the business needs changed.
Now as our patient population is growing, one provider may not be able to see the patient twice a week; we may have to use a different provider to see the patient the second time.
How to reflect the patient load correctly for a provider in the report.
I'm thinking of keeping one Provider as the Primary DCA and adding a second column as an Add-On DCA. Can you suggest a solution please.
I added two screenshots. first is the patient and the provider(DCAs) tracker, and the second is the report.
-
@Dheeraj.c16 I think you are on the right path. I would add another column or two to capture the additional DCA's. Utilizing reports with summaries is great for tracking the work load if you don't have resource management add on.
Ken Armstrong
Smartsheet Project Manager, GE Aerospace
Certified Smartsheet Administrator
Be Firm! Be Fair! Be Friendly! Be Honest!!!
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
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!