So, I have a "Done" column and a "Status" column.
Status column values = Not Started , In Progress, Complete
Done value = Checkbox
When I check the "Done", I would like to have the Status column show Complete. I have partially achieved this with the following formula: =IF([email protected] = 1, "Complete")
However, if a manual value is inserted first, this formula does not work.
Is there a way, maybe with conditional formatting, to override the manual value of the Status column and always set to "Complete" when the checkbox is checked?
Thanks in advance!