⚠️ The document format changed in version 3.0, so version 2.0.6 and earlier won't be able to open documents opened in version 3.0.
🖥 SheetPlanner now requires macOS Catalina (10.15) or later.
Multiple sheets and tabs
Everyone can now use multiple sheets and tabs in a document.
A sidebar is available to organize multiple sheets.
Sheets, Notes, and Links can be displayed in a new tab.
These were previously only available to paid users; now also available in free mode.
Saving to iCloud Drive is now supported. New documents are saved in iCloud Drive by default, but can be saved elsewhere if desired.
When saved to iCloud Drive, sharing options are available. See Share ▸ Share File menu, and the Share toolbar button.
Detects when a document is changed on two or more computers at once, and merges the changes, to avoid one overwriting the other's.
Now uses Quick Look preview and thumbnail app extensions to dynamically provide those to the Finder, to avoid conflicts when editing a document on multiple Macs.
Quick Look previews can be zoomed and scrolled, though are static snapshots of the window content.
Added support for Mac-specific bookmarks for file links, so finding a file on one Mac won't invalidate the link on another Mac.
The showing state of notes and links is now also Mac-specific.
Changed the way the outline hierarchy is restored when loading a document, to minimize changes needed to be saved, thus reducing conflicts when syncing.
When another Mac makes changes to a document, the changed cells are briefly highlighted.
Added a command to Show/Hide Highlights. When shown, all cells that have been edited are highlighted with the person's color. When hidden, cells are only highlighted when changed remotely.
When two or more people are editing the same document at the same time, the other people's selections are displayed as thin lines, using their highlight colors.
Added a standard People column, hidden by default, that is a List-type column pre-populated with the names of people collaborating on a document.
When the People column is displayed, it works the same as other List columns: click the menu button to show a menu of people, or type a name. The cell also displays the selected person's color; this color is used to highlight their changes.
Can add and remove custom people via the Inspector.
Collaborators and custom people use different icons in the People column.
In the Column Inspector, the color assigned to each person can be changed.
Also in the Inspector, the names can be edited, e.g. to use a shorter name.
The Inspector also includes an option to choose multiple people, or only one.
When one or more people have been assigned to a row via the People column, and a notification is set for a date column, now only those people are notified.
Updated the Project Plan and Sales Pipeline templates to use the People column instead of a custom List column.
When a cell that has been changed is selected, the Cell Inspector now displays information about it, including:
The date and time the cell was last changed.
The highlight color and name of the person who made the change.
The name of the computer where the change was made.
Added the ability to filter on Row attributes, like whether a row is a task (has a duration) or milestone (no duration), is a parent (has sub-rows) or a child (no rows within), is unchanged, was changed by you, or was changed by someone else, etc.
Fixed the Note filtering to properly support searching within notes, from start of notes, etc.
Smart filters now support filtering on the People column.
More compact documents
The SheetPlanner document is now a single file, instead of a package (a folder of files presented as one file).
This makes syncing faster and more reliable, in addition to taking up less space on disk, among other benefits.
Note that documents opened in version 3.0 and later won't be able to be opened in version 2.0.6 or earlier.
Documents saved by SheetPlanner 3 use the file extension ".sp".
Added a command in the Debug menu to open the diagnostic log file, that records information to help debug the app (it is replaced each day).
Also added a command to open the Console, which logs that and other Apple framework detritus.
Added Debug menu options to add the computer name or app edition name to the person name. Useful to test the People column without multiple people.
On macOS 11 and later, the window now has the title above the toolbar, instead of to the left, so toolbar buttons are spaced out instead of scrunched to the right.
When a cell is selected, the color picker is now updated to reflect the text color of that cell.
The Inspector no longer scrolls to the top when changing the cell selection etc.
When a document is saved, its print settings are saved as the default.
When a template is loaded, the default print settings are loaded.
When opening a template, the sheet name now defaults to the template name.
When adding a sheet to an existing document, the sheet name has a number appended to make it unique, if necessary.
As a special case, adding a blank sheet uses the name "Sheet", with a number if needed.
Fixed row numbers being zeroes when using Duplicate Sheet & Rows.
Fixed a curly issue where a cell could unexpectedly stop editing.
When copying a Topic cell with notes and/or links, those are now also included when pasting into a document.
When opening a document on a different computer, the first sheet is selected by default, instead of none.
The Month and Year view headers now better adapt between light and dark modes.
Fixed Month and Year views not updating when in a different tab (not a sync-related issue).
Updated the Welcome to SheetPlanner screens.
Big Sur compatibility
Updated the app icon and sidebar icons for the new Big Sur style.
Updated for Big Sur (macOS 11) compatibility, but still supports back to High Sierra (macOS 10.13).
SheetPlanner is now a universal app for Intel and Apple M1 silicon.
The Outline view can now be used free of charge, including all outlining features, and saving documents.
When in free outliner mode, the toolbar and menus are simplified to omit paid features, including the Sidebar, Timeline, Month, and Year views, smart filters, and multiple tabs.
In free mode, if opening a document that contains multiple sheets, they appear as multiple unclosable tabs.
The purchase bar at the top of the window now only appears during a trial of the paid features.
When first running SheetPlanner, a window will appear with a slideshow introducing the features of the app. This can be re-displayed later via the Help ▸ Welcome to SheetPlanner menu command.
When updating to a new build of the app, a window will appear with "What's New in SheetPlanner". This can be re-displayed later via the Help ▸ What's New in SheetPlanner menu command.
When the app hasn't been purchased, a window will be displayed with options to use the free outliner, start a trial, unlock the full features, restore a purchase, or learn more.
Even if the trial has been completed in version 1, it will be available to try again in version 2.
After the unlock page, a newsletter signup page will be displayed. This can be re-displayed via Help ▸ Sign Up for the SheetPlanner Newsletter.
Help & Tutorials window
Added a new Help & Tutorials window.
This is displayed via the Help ▸ SheetPlanner Help menu command.
Includes a sidebar that lists the help topics and video tutorials.
Clicking a help section displays the help for that topic.
Clicking a video displays the corresponding video tutorial.
Multiple sheets in a document
Added a sidebar to the left of the Outline view in the document window, including built-in and custom folders and sheets.
A document can now include multiple sheets, each with their own columns, rows, styles, filters, etc.
Built-in folders include all sheets, recently accessed sheets, favorite sheets, and deleted sheets.
Each tab or window of a document can have a different sheet selected, and each with their own shown views and selections.
Added items to the Add toolbar menu to add new folders and sheets.
Added a new Sheet menu to the menubar, with commands to add new folders and sheets, duplicate, rename, delete, and navigate between sheets.
Can click on a selected folder or sheet to rename it.
Can click the star icon on a selected sheet to mark it as a favorite.
Folders and sheets can be dragged to rearrange them.
The view state is stored for each sheet of each tab of each computer.
The selected sheet name is displayed in the window/tab title.
This is only available in the trial and purchased modes.
Document changes for multiple sheets and future sync features
Major changes to the document format to support the big new feature of multiple sheets in a document.
Support for organizing sheets into nestable folders.
Support for multiple people and/or Macs editing a document via cloud syncing (coming in a future version), each with their own tabs, sheet and cell selection, etc.
Numerous changes to improve the performance of document access.
Plus other changes for the latest version of Swift.
🚧 NOTE: the document format has changed, so documents opened by this version onwards can't be opened in version 1.2 and earlier.
Added a File ▸ Save as Template… command to save the current document as a custom template, that you can use as a basis when making new documents.
Custom templates are listed in a new "My Templates" section of the Template Chooser (which is only included if some have been saved).
Right-click on a custom template in the chooser for menu commands to rename or delete it.
Improved the Template Chooser to work better from the keyboard: you can now just arrow around to select a template, then press the Return key to open it.
Updated the appearance of the Template Chooser window.
Added support for importing documents from Caboodle, maintaining the hierarchy and content of the entries.
Custom fields are added as columns, and entry text are added as notes.
Supports both version 1 (from Dejal) and version 2 (from Before Dawn) of Caboodle.
If any encrypted entries are encountered, you will be asked for a password, or can skip them, or stop the import.
If the same password is used for multiple entries, you only need to enter it once; it'll only ask again for unique passwords.
Changed the style scope popup menu to rename "All at This Level" to "Level n Rows", where "n" is the selected row number.
Removed the Parent/Child option, since that caused confusion.
When the scope is changed to "Level n Rows", the level style is applied to the selected row.
Existing documents are updated accordingly.
If only one cell is selected when pasting text with multiple lines and/or columns, it will now overwrite (and select) adjacent rows and/or columns.
If more columns than are available are needed, new ones are added at the end.
If more rows than are available within the parent of the selected cell, more are added at the end of that parent.
If the selected cell is the last within its parent, added rows can reflect the hierarchy of the pasted text. The hierarchy is ignored if overwriting adjacent cells, to avoid changing existing hierarchy.
If multiple cells are selected, pasting only populates those cells, as before.
Copying and pasting now uses the displayed column order; previously the order could be different if columns have been moved.
Choosing the Print… command now transforms the window into a print preview.
When in the print preview, a Print… button in the Inspector and the Print… menu command displays the standard print sheet to actually print.
When in the print preview, a Done button in the Inspector and a File ▸ Done Printing menu command enable exiting the print preview.
The print preview always uses the light appearance, even when the Mac is using the dark appearance, to match the paper. Defaults to Plain theme, but that can be changed.
The Outline and/or Timeline views are displayed so that all of their columns are visible. The Month and Year views can not be printed yet (coming in a later version).
Outline and Timeline views are fully editable in print preview mode. Cells can be edited, rows can be collapsed or expanded, filters and focus can be used, etc.
The preview can be zoomed in or out via a pinch gesture on a trackpad.
The Inspector includes a Print pane with pop-up menus to choose the printer and paper size.
The Print Inspector also includes graphical representations of the page to toggle between portrait and landscape, plus top, bottom, left, and right margins.
The Inspector includes checkboxes to include the row numbers and/or column headings when printing.
The views can be scaled via a slider or percentage field in the Inspector, so they fit a desired number of pages, with a Fit button to fit their width to one page.
Page breaks are indicated with dotted lines; they are aligned to the gaps between cells.
The Preferences window has been split into two pages, with the usual page-switching toolbar buttons.
The General page includes behavior options like whether to use a template, the Return and Tab key options, etc.
The Appearance page includes cosmetic options to apply as defaults in new sheets, like the theme and font, plus new options for the completion and topic style, finish date options, timeline options, and calendar options.
The default text color now uses an enhanced color well, with the pop-up swatches.
Tweaks and fixes
The focus path and dismiss button are now displayed in the Topic column header instead of a separate bar.
Changed the Show Completed Rows option to support three options: Show Completed, Show Completed Today, and Hide Completed. The new today option leaves just completed rows visible until the following day, so recently completed rows can be referred to if needed.
Added a pop-up menu to the Import open panel to choose the destination of the import: a new document, or a new sheet on the topmost open document.
If holding Option when clicking a view in the toolbar, that view replaces the current view(s) instead of adding another one.
Can now sort (via the Organize ▸ Sort Once submenu) by the Added Date to get back to the order rows were added, or by the Changed Date to see the recently edited rows.
Changed the Filter menu to have the filters at the end, instead of the start, to match the Sheet menu (and other apps).
Disabled the limit of making the Topic column narrower than the total custom columns, so blank space can be left to the right of the last column if desired (I can easily re-enable it if we want to go back to the old behavior).
Re-sampled each of the color palette colors to match those in Apple Numbers.
Changing between light and dark modes now refreshes the Inspector, so it shows the correct color.
The label for links now uses a color with more contrast. Also increased the text length before truncation, and fixed a layout issue with multiple long links.
When showing or hiding the filter bar, other tabs are now updated to match that state.
When hiding the note or links, now exits editing mode.
The tooltip for the Connect toolbar button changes between Connect Dependency and Disconnect Dependency as appropriate.
Fixed updating the dates when loading the Expense Tracker template.
Replaced the icon for the Completed options in the toolbar with a tri-state one.
Fixed parent rows with some completed children not appearing when showing Completed Today.
Fixed changing the completed options displaying rows as collapsed when they shouldn't be.
Fixed updating the Timeline and calendar views when changing the focus.
Clicking a cell next to a link now selects the cell.
Fixed showing notes and links in a new tab.
Adjusted the dark variation of the Yellow Notepad theme.
Fixed row menu items with submenus not applying their items to the clicked row.
When opening a new document or sheet from a template, the Added and Changed dates are set to the current date and time, with a 1-second offset for each row, so sorting by Added Date will restore the templated order.
If the dates for the Timeline are more than ten years ago, only those dates are displayed, rather than including today in the range.
Added support for a minimum Timeline scale of years.
The Timeline tooltip now only includes dates that have their "show in timeline" Column Inspector option checked.
Fixed the undo for a Clear Value command saying Undo Delete instead of Undo Clear Cell.
No longer beeps when reaching the beginning or end while arrowing between cells.
Changed the name picker (e.g. for saving a smart filter) to include buttons to cancel and save the change, as alternatives to pressing the Escape or Return keys.
Changed the date picker to not automatically dismiss when clicking on a part that doesn't change the date (e.g. the month name, or dates in previous or next months).
When multiple rows are selected, the Edit ▸ Duplicate Row menu command becomes Duplicate Selected Rows, and similar for the row menu.
If the preference for new documents is set to a fixed template, but one hasn't been explicitly chosen, now defaults to Blank (which is the first in the menu anyway).
Adding rows, indenting, and outdenting are now disabled when using a filter, since they don't make sense in that context.
Fixed the filter criterion value popup not always appearing for Symbol columns.
Improved filter criteria on Symbol columns to work properly with unchecked symbols.
The Show Note in New Tab menu command is now always visible in the row menu. (It appears in the View menu when you hold the Shift key.)
Fixed a template opening in a new tab of an existing document.
Fixed a crash when dragging a row into its own children; that shouldn't be and no longer is allowed.
When editing a date cell via the date picker, other cells are now immediately updated. (Editing by typing in the cell updates when leaving the cell, to avoid unnecessary updates for incomplete dates.)
Fixed using the date picker in the Inspector vs the Timeline or calendar info popover.
Now shows the Show/Hide Completed toolbar button menu when clicking instead of clicking and releasing, for quicker access.
The Connect toolbar button now shows the connected/disconnected state in its icon (with an arrow when connected, none when not). It also shows it immediately on click, rather than after completion the operation, to appear more responsive.
Fixed a crash on High Sierra and Mojave when accessing the Window menu.
Reimplemented the Shift-selection behavior to create rectangular selections, anchored from the initial click point (so can be reshaped with each Shift-click or Shift-arrow), in the same way as Numbers etc.
Updated the row selection functions (clicking the row number to select the row, the Select row commands, etc) to select the whole row and support rectangular selection adjustments.
Fixed undoing the Timeline Shade Weekends option in the Inspector.
Fixed undoing dragging the Timeline bars.
Improved linking to a website when the URL has spaces around it, by trimming off those spaces.
When dragging files to a document to link to them, now only highlights the row under the drag.
Fixed an issue where dragging parents and children could lose their hierarchy.
When copying selected cells, the text lines for child rows are now prepended with spaces to preserve the hierarchy.
When pasting text with a single cell selected, or while editing, when adding rows it now looks for space prefixes to preserve the hierarchy.
Fixed the Show All Notes and Show All Links not toggling to their Hide variations.
Fixed inability to change the Style Inspector from All at This Level to Parent/Children at Level.
Fixed the text color defaulting to black on dark mode for some new users.
The Preferences window now updates the text color when changing between light and dark modes.
Added a new Picture column type, that can include pictures within the document.
Pictures can be dragged or pasted, shown as thumbnails, and have a larger Quick Look view.
Can now optionally choose multiple items in List cells.
Each cell can now have its own style, including font, face, size, text style, justification, and color.
Replaced the Style Inspector font button with separate pop-up menus, and added an alignment control.
Can now add a notification for Date cells, a specified interval before the date.
The Timeline view now supports an editable info popover when double-clicking on a bar.
Added a Date Stamp function.
Plus numerous other improvements; see the website for details.
Changing a Date column color, or toggling the show checkboxes, is now immediately reflected in the Timeline view.
Fixed the Outline Columns submenu showing incorrect column names after adding or removing columns.
The Progress column is now shown in the Project Plan template.
If you open a template then close it without making any changes, it now doesn't ask if you want to keep it.
Added the ability to connect rows to establish a dependency.
Dependencies are displayed via arrows in the Timeline, and new optional columns in the Outline.
A red vertical line now marks the current date & time in the Timeline.
Any Date column can now be included in the Timeline.
New Symbol column type, including checkbox, flag, star, color icons, bullet journaling, Eisenhower quadrants, 5 stars, etc.
New Progress column type, displayed as a progress bar, mini pie chart, or percentage.
Auto-enter cell values with a default value, from the row above, today, formatted serial number, and more.
Outline view menu improvements.
Filter improvements, including better search for dates, time intervals, note text, and more.
Printing the Timeline is now supported, and printing the Outline is improved.
Plus numerous other improvements; see the website for details.
Fixed a layout issue with the calendar views when always showing scrollbars is enabled in the System Preferences.
Fixed issues with editing Number column values in some Euro countries.
Fixed a crash that could occur when changing Preferences after closing a document.
Fixed an issue where a document could not be opened.