With Slicers, you can analyze your data much more interactively. The date slicer has to filter records in a way that the FROM and the … Google Sheets is constantly releasing other new features to create more engaging spreadsheets with interactive reporting features. The QUERY function in Google Sheets is a powerful function that helps to operate on a range of data, however, on a current project I needed the QUERY function to ignore rows where a certain column was empty.
Now, all blank rows are hidden, and you can sort the data range.
They announced a ton of exciting new features and products for both G Suite and the Google Cloud Platform. Google Sheets – SUM or COUNT Values If Cells Have Notes.