Checkboxes in Pages Spreadshets

Here is another spin on a portable solution when exported to Excel, at least on a Mac.

You will need to enable the characters palette from Numbers Edit menu : Emoji & Symbols menu item. When that panel is up, you enter the word, check in the search window, and choose either ballot box with check. Pick a cell in Numbers that is formatted text, and double-click on the ballot box symbol. It will insert into the selected Numbers cell. Again, in the search window, enter the word box, and scroll to the bottom of all those characters until you see the empty ballot box. Select another cell in Numbers, and double-click to insert it there. Done with the characters palette.

There are two formulas in the spreadsheet.

1. Inspect column 1 cells for a "YyNn" character and insert the appropriate box image in the adjacent column 2. This is achieved with a vlookup conditional. Column 2 cells have their text sized to 20 points for better box visibility.
2. If any entry in column 1 is "Yy" then add its amount to the total, and if "Nn", then subtract from the total.

Hi V,

Go back to the Numbers version of your table and reformat the checkbox cells as text.

(example shown before changing format of column A)

If you want to keep the current checkbox settings, replace all now reading "TRUE" with either "t" or "y".

Revise the formulas depending on the checkbox values to a version similar to that below:

Copy the table, ten paste it back into the Pages document.

Regards,

Barry

EDIT: Came to this directly from my subscription list which was reporting no replies as yet. I see my solution is the same as that arrived at by the OP. 🙂

It was what it is, whatever version it is.

Check boxes exist as various OpenType glyphs. Try creating a cell formula when = True shows a check box with a tick in it, else a checkbox without a tick.

Peter

Checkboxes have never been supported in Pages tables as a data format. There is no fix for a data format that is not engineered into the application. Numbers is a spreadsheet, and not a word processor. There is your dilemma.

Could you please elaborate a bit more as to what version of Pages you are using...

A glyph = a character. Letters and letter-like black and white graphics.

OpenType has an enormous number of glyphs, covering all the characters in all known languages, even fictious languages like Klingon, plus punctuation, numbers, pictograms, dingbats etc.

Peter