I have a slider quick filter on a workbook view that needs to default to the maximum value in that column every time the view is opened. Is there a way I can achieve this?
I have a quick filter for a column called Survey number. The maximum value of survey number today is 100. So my filter should default to 100 when a user opens the workbook today. Tomorrow the max survey number value changes to 110. So the default value for the filter should change to 110 when the workbook view is opened tomorrow.