Create calendar

That calendar design only works if you were to print it out on paper and write appointments on the paper.

If you want to use a Google Sheet to store appointments by date and time, start a new sheet with three columns:

  • date of appointment (Numeric, with yyyyMMdd formatting)
  • time of appointment (numeric, with hhmm formatting)
  • text of appointment

See the Spreadsheet Component Help for how to request rows using a filter.