Sign in to join the conversation:
It looks like you only want to show things delivered in the past but not yesterday. Is that correct?
You can get this behavior by excluding the future and then also excluding the last 1 day.
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
I just started using the Table View for lists of contacts. I added a Format Rule that would highlight the entire row (except the Email Address field) if the Email Address cell is "blank". A second rule highlights just the Email Address cell itself in a slightly darker color if Email Address cell is "blank". This gives a…