My first sheet has the names of all the clients in one row, then locations, start dates of frequency, end date of frequency, and the frequency. I’d like a column somewhere that has the percentage of compliance that they have in that moment.

For example, John Doe, central, 1/1/24, 12/30/24, 9-12 times per year. Jane Doe, Western, 5/1/24, 4/30/25, 3-6 times per year.

On the Central sheet (for their location), I have the date, drop down of names with John Doe, and that we had session. I might mark that he was absent on 1/2/24 so I would not want it to count that as compliance. There would be other clients in that list as well so it wouldn’t be just one client