In order to have different filters for different users, I have added the UserEmail to filter table and using lookup in the filter form but this doesn't seem to be working, I think the updates are too slow. Has anyone any other ideas how this can be achieved. UPDATE : I have put the filter columns on the table that lists the users and lookup from there which works.
I finally got my dashboard to work thanks to this video. Your explanation is easy to follow and logical. Is it possible to modify the filter expression to be able to select multiple criteria within the same column? Let's say I like to filter low and medium, and exclude high within the same column?
Many thanks for the tutorial 👍
This is by far the best explanation and example I've found. Thank you very much!
Great content from South Africa 🇿🇦
If you want to use the Enumlist in the filter. make sure the filter data set has an auto compute to your enumlist in the Suggested values
In order to have different filters for different users, I have added the UserEmail to filter table and using lookup in the filter form but this doesn't seem to be working, I think the updates are too slow. Has anyone any other ideas how this can be achieved. UPDATE : I have put the filter columns on the table that lists the users and lookup from there which works.
I finally got my dashboard to work thanks to this video. Your explanation is easy to follow and logical. Is it possible to modify the filter expression to be able to select multiple criteria within the same column? Let's say I like to filter low and medium, and exclude high within the same column?
It is necessary only one row in the tab Filter of google spreadsheet?
Isnotblank can be used
Hi, i have a case where to include blank values in the filter condition. How to text you? Could you please help me with this?
great lesson from thailand
It is a great tutorial, thank a lot.
Glad it was helpful!