I am using the multifield formula to try to change all values in the cells Mon/Tue/Wed/Thu/Fri to True if 'Frequency' is 'Adhoc' and all values in Mon/Tue/Wed/Thu/Fri are False.
However, when I run the formula, the values in the Mon-Fri cells remain False, when they are all False.
The data looks like this before/after running the formula, but after running the formula, they should all be True.
FREQUENCY | MON | TUE | WED | THU | FRI |
Adhoc | False | False | False | False | False |
Here is my formula:
if [FREQUENCY] = "Adhoc" and
[MON] = 0 and
[TUE] = 0 and
[WED] = 0 and
[THU] = 0 and
[FRI] = 0
then [_CurrentField_] = -1
else [_CurrentField_] = [_CurrentField_]
endif
I selected BOOL fields MON, TUE, WED, THU and FRI as __CurrentField__
Can anyone help answer why the values don't change?
Solved! Go to Solution.