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 |
---|---|
25 | |
15 | |
4 | |
3 | |
3 |