Robert. Thank you. I have been watching a lot of your videos. But my main concern is that I still have to add in roles for every business member. Why doesn’t my filtering rule work in this instance? Is there any other Google sheets automation I can do to speed this up?
Bit difficult to say, but it looks like you might be using “is included in” where you should be using “includes” - what does the Email column actually contain?
Question: How important is data security? That is, if a user from one company is able to discover the data of another company, would that be a problem? If it would, then filtering is not the correct solution.
Mr Murphy, thank you for your response. Filtering by company is sufficient for their usage. They just want to see their own data pertaining to their company, but none is sensitive for an individual user.
My email column contains “@domain.com” In theory the statement should work, but it never gave me the desired outcome.
I knowingly tried every operator available, but none of them gave me the results I desired. I swapped values and effects as well :(.