Data Validity Help

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

0 2 98
2 REPLIES 2
Top Labels in this Space