CollabOS / Docs
Docs/CollabOS Sheets/Comments, charts and printing

CollabOS Sheets

Comments, charts and printing

Choose Comments to read the spreadsheet conversation. Select a cell and post a comment when you have Commenter, Editor or Owner access. Comments identify their author and worksheet cell address. Authors can remove their own comments; owners can remove comments on their document.

To insert a chart, select a table containing a header row, a label column and at least one numeric column. Choose Insert chart, enter a title, and choose Bar, Line or Pie. Charts follow their selected cell range and appear in the Charts panel. Pie charts use the first numeric series. A chart supports up to 500 rows and ten columns; a workbook supports up to 30 charts.

Print worksheet prints the active worksheet's used cells, including merged section headings and basic cell formatting. Your browser supplies printer and PDF options.

Finalized Native raffles and supported Alphabot/Tessera raffles created through CollabOS create or update a winner spreadsheet for the manager, community and project. Different managers and communities have separate sheets. GTD, FCFS and WL results stay in separate sections, with column headers followed by winner rows. Available identity fields and native custom-question responses determine the columns.

Generated winner sheets start with Anyone with the link → Viewer access. Recipients can view without signing in. Owners can change this in Share. Blank spreadsheets still start Restricted. Automatic updates do not reset an owner's sharing choice.

Generated winner sheets include saved Team export rows after genuine winners, without increasing the winner count. Choose Wallet addresses only before opening a sheet to create a separate wallet-only export; this leaves the full sheet unchanged. Sync all CollabOS Sheets updates the selected project's community sheets. Open all CollabOS Sheets prepares and opens those sheets, reporting any communities that fail. In wallets-only mode, Prepare all wallet sheets creates separate wallet-only exports.

Quick Giveaway details offer Entries in CollabOS Sheets and Winners in CollabOS Sheets. These create export snapshots using the selected list, including collected wallet details. They do not need a Google connection.

Open in CollabOS Sheets is available on the Winner exports page and in result notifications. Personal webhooks include a normal link; community bot messages can include a link button. Discord /raffle export-raffle, /raffle export-project and /raffle export-select offer CollabOS Sheets alongside the existing CSV and Google Sheets options. Choose the CollabOS Sheets format to select already-generated Native, Alphabot or Tessera results. Discord exports create separate snapshots containing only the selected raffles; unselected raffles from the main community sheet are excluded. The provider choices use cached sheet links and do not fetch external provider data during autocomplete. Existing export options remain available.

As soon as finalized results are available in a generated winner sheet, its existing CollabOS Sheet link is automatically appended to the matching project row’s Winners Sheet cell. Pending raffles do not block the link; later results update the same sheet. No setting or toggle is required. Different managers’ sheet links share that same row, separated by commas; existing Google Sheet or other sheet links are preserved and duplicate URLs are not added. One link opens directly from the cell’s Open link icon. Multiple links open a dropdown, labelled by manager where that information is available. Discord /pullsheet and tracker search recognize generated winner sheets as well as saved links. Existing Discord winners-sheet add commands append links to the same cell, and team members can still edit the comma-separated links manually.

Choose Add to tracker as the sheet owner, search for an existing project row, and choose Add link. This writes the URL into that row's Winners Sheet cell; it does not create a duplicate tracker row. Generated sheets can link only to the matching community and project. Enable Keep this cell linked automatically to retain that mapping for future winner updates. Automatic linking will not overwrite a different URL entered in the cell. Replacing a different existing link manually requires confirmation.

Repeated result checks do not append the same raffle's winners again. Ordinary cell edits and additional columns are retained. Keep generated winner rows and their worksheet intact: deleting or duplicating these rows blocks further synchronization rather than overwriting your work. Restore the sheet from version history before trying again. If automatic generation fails, existing CSV/Google delivery remains available and opening the sheet from Winner exports retries generation.

Provider results use the existing bounded result polling and require a valid provider connection and current manager access. Discord notifications remain opt-in; sheet generation does not enable notifications. Earlier finalized raffles can be added by choosing Open in CollabOS Sheets on Winner exports. Existing CSV and Google Sheets integrations are unchanged.