Sign in to join the conversation:
HI, having created a report which is a summary of several sheets, I can easily sort it...but I cannot see a 'filter' option on the report.
Does anyone know if this is an option?
cheers
mike
Hi Mike,
There isn't a filter as in a sheet but you could use the Report Builder to filter as needed.
Would that work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Report builder doesn't work for my use-case, as it would change the data shown to everyone, and the report is something that needs to have a consistent view that a team can further filter to find what they need. Editing the report builder adds significant risk of user error that affects a wide group of users.
Would it work if you created a copy of the main report that would only be used for filtering?
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…
