Tracking Changes in Scores Over Time
We track changes in PHQ-9 and GAD-7 scores for patients who have a certain number of collaborative care appointments. I want to show an aggregate widget on the dashboard for all active and relapse prevention patients, which would mean calculating averages based on each session score for multiple patients. I am having trouble creating a formula that will calculate this and also want this to be automatic so it is complex. Anyone have any ideas for sheet summary formulas?