Hi Everyone,
Im hoping someone can point me in the right direction.
I have a list of clients in a google sheet table, from that list I can assign them a session from another google sheet table, the clients are only authorised a certain number of sessions per case. I am tracking the number of attended sessions and also the number of authorised sessions. I have created a virtual column that tells me if they have maxed their session allowance or if they have available sessions.
If I want to stop the user from adding anymore sessions how would I go about this? Is it something under data validity, if anyone could point me in the right direction I would be really grateful.
Regards
Ben
User | Count |
---|---|
28 | |
27 | |
22 | |
22 | |
22 |