Forum Discussion
MarinaSaadalla
Mar 07, 2021Copper Contributor
Tracking for patients
I'm working on a project. I need to track the patient movements within 14 days if he/she went to same service within 14 days so it will appear with different color as the sheet contains around 16k me...
Yea_So
May 07, 2021Bronze Contributor
I filtered it the old fashioned way much faster
I created 2 helper columns at the right most side to filter in:
1. any dates that are duplicates
2. by Assessment
Then you can spot check to see if anything interests further investigation or you can filter it by card to view the details of the multiple transactions on that same date. Let us know if that helps