I am building a Google Sheet to use as a very simple CRM among a team of people. Each of the people works at a Site, each of the Sites is in a Region. I want to establish Temporary Flter Views for each of these: each Region (column A), each Site (column B) and each person (column C).
I began this badly. The old ones need to be deleted. Then the new ones need to be created. I have a tab of data that populated the Data Validation fields that are the complete list of Regions, Sites, and People that need a temporary filter view for each.