I am trying to add a checkbox column that when checked changes the value of another column.
In our order tracking table, we have a status column. When working on orders, the status is changed as the various phases of the process progress.
What I was wanting to add with the check box was that when we ship 50 or 60 packages, we can quickly go through the table clicking checkboxes and changing the status to “Shipped” quickly.
I don’t know if I assign a formula in the “check box” column or the “status” column. and what should the formula be?