I am using Calc for a weekly reservation list. The list includes name, date, time, contact info, group size etc. We regularly sort the list by date then by time. On occasion we have cancellations. I want to create a checkbox that would indicate a reservation was cancelled (it would strikethrough all the cells needed for that reservation).
But…when I sort, the checkbox follows but the linked cell does not update.
Can I make that linked cell change in a sort?