Using Checkbox to Set the value of a second checkbox in same sheet
I have searched for awhile and have not found a solution.
I have two columns. [Waitlist] and [Waiver Granted]. Both use Checkboxes.
For this subset of data, [Waitlist] is generally true (checked) for each row.
I want the user to be able to check the checkbox in the [Waiver Granted] column in one row and have it automatically uncheck the [Waitlist] checkbox for the same row.
I would prefer for the formula to be in the [Waiver Granted] column since its a relatively rare change. Finally, the data is likely being displayed for the user in a Report, is there a way to force the report to update after the box is checked?
Help Article Resources
Check out the Formula Handbook template!