Sheets —
Calls this load —
Backup —
--:--:--
Loading…
Loading…
Load tabs above to choose which ones to pull tasks from.
These three are what turn a row into your task: which row holds the headers, who it's assigned to, and its status.
Date assigned drives the age badges and oldest-first sorting.
Any column with a permanent, unique value per row will do — a serial number is ideal. Saving re-finds the row by that value, so sorting the sheet or inserting rows can't send a save to the wrong task. Without one, tasks are matched by row number only. Save settings before checking — the check reads the saved configuration.
Due date and priority are read-only — the app shows them but never writes to those columns.
Comma separated. Blank uses your global list.
Blank uses your global submit status.
One rule per line, From -> To. When set, ONLY these statuses can be submitted, each to its own target. Leave blank to let any status submit to the status above.
Mapping by header name survives someone reordering the sheet's columns. The letters above stay as the fallback.
A field's column accepts one letter (all tabs), or a comma list matching your tab order (e.g. G,N). Use a dash to skip a tab. -,N means “no column in the first tab, N in the second”.
Piece of one job is for a sheet where one row holds several things the same person writes — a post and its comments. Tick it on each of them and they stop being separate tasks: the queue shows one card with a progress count, and the pieces are written inside it, in the order they appear here. Tick written in a Google Doc on the one that lives in a Doc rather than a cell. Leave them all unticked and nothing changes.