I have a spreadsheet that "lives" on SharePoint with a large number of people collaborating on. I think because the document is on SharePoint or the data is in a table, custom views are not an option.
Below is an example of the spreadsheet/table. I am looking at how I can do the items below. Some I will have to do on their own and some in combination. Is there anyway I could have it perform different functions for different users for sharepoint?
- ONLY show rows that are dated Today or in the future - ONLY show rows that have "Yes" in the cells for column C - ONLY show rows A,B,C,D for Team 1 - ONLY show rows A,B,C,E for Team 2