So I have two sheets one which covers services and then another with people who are validating that these services are valid.
Service A with a column validated by in services table.
Multiple entries with service A and validated by exists in validators table
A user can add any services to the services table.
Any user can click on validate column of service and fill in his name and then the validators table will be filled with the service name and name of a validator.
What I want is to aggregate the values in
validated_by in the validators table and bring them to services table. Also, I want to check the number of
validated_by aggregate and set another value as verified=true based on a condition that sum(
validated_by) > 5.
I cannot find anyway to do this after extensive google search. I searched for
aggregate value in worksheet to another worksheet etc.
Any help is appreciated