Apple Numbers formula for tick box

Hi there.

I am wanting to create a formula for a tick box. For example, if I select Paid, from the drop down menu in W2, the tick box is automatically ticked in D2. There are other options in the drop down menu in W2, however I only want it ticked if 'Paid' is selected. Is this possible?

iMac 24″, macOS 14.1

Posted on Nov 17, 2023 12:28 PM

Top-ranking reply

Recycleur

Level 4

1,633 points

Posted on Nov 17, 2023 12:33 PM

No. A cell with a check box cannot also contain a formula, which would be required in that case.

The only alternative is something like IF(W2="Paid","X","")

View in context

Apple Numbers formula for tick box

Similar questions