I have a google sheet with the first column giving the dates of particular events. Ideally, I'd like to have two side by side versions of the spreadsheet, one with cells before todays date and one with cells after todays date.

  • 1
    Welcome to Web Applications. You might use functions like SORT and QUERY and the filter / filter views features. If you need further help, please show what you tried and add a brief description of your search efforts as is suggested in How to Ask.
    – Rubén
    Sep 30 at 15:00
  • Thanks. I had originally tried filter views, but wanted the past and future cells in separate side by side sheet. I managed to use sort and query as suggested.
    – odee
    Sep 30 at 15:31
  • Please edit the question to show what you tried to help others better understand what do you mean.
    – Rubén
    Sep 30 at 15:39
  • For a query that has a criteria based on the data, this webapps question and answer is helpful: How to make a query with Google Spreadsheet, that checks for a date. Also, the query documentation on literals.
    – Tedinoz
    Oct 2 at 1:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.