Updating rows without re-running filters

Hi. I'm an active user and have a filter that hides "done" rows. As I'm working, I frequently marking stuff as done, but it rarely if ever hides the rows with that new information. In order to make the rows actually hide, I need to turn off the filter (which causes a page reload), and then turn it back on again (yet another reload).

Is there a better/easier way?

Screen Shot 2018-04-18 at 1.41.06 PM.png

Find more posts tagged with

Sheets

Comments

Chris McKay

Hi Matthew,

Unfortunately not that I know of. You could always add a conditional format to quickly denote rows that have been marked complete ahead of them being hidden when the filter is refreshed.

Kind regards,

Chris McKay

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…
True up and the admin center
Hello We converted over in July to the usm. We have alot of discrepancies where people are in usm and not the admin center and vice versa. Is anyone else see the same and feel this is an issue? Also, I would like to brain storm with the group as to how procedurally you will be doing the true up process and terminations as…