Hi there!
I'm trying to create a formula using a checkbox and I'm really struggling. Using the parameters below, can anyone help me with the formula?
Column 1 = Australian states/jurisdictions (SA, WA, etc)
Column 2 = Complete column with checkbox
PROBLEM: If Column 2 is checked in Row 1, I want Column 1 in Row 2 to automatically populate with 'SA'
Any assistance would be greatly appreciated!
Thanks,
Phoebs