Hi, I want to use a helper column to uncheck a Checkbox column if a certain condition is met.
i.e. If [Order Date] contains a date then [Order Required] is unchecked. I can't put the formula into the [Order Required] column as it already has a =IF(OR(ISTEXT([Quantity Required]@row), ISTEXT(Unit@row)), 1, 0) formula in it. Is it possible to have two formulas controlling one cell? And if so which is given preference or can this be controlled?
If the above isn't possible is there a workaround which would allow; when a checkbox in one sheet is checked it will populate a Report, when the [Order Date] column is populated from within the Report that it would automatically uncheck the Checkbox?