Hi All,Am building a nested If statement to update a field based on the values of two fields:IF(OR($(FIELD_A)="VALUE A" & $(FIELD_B)<>"VALUE X'",$(FIELD_B)="NEW VALUE",IF(OR($FIELD_A)='VALUE B" & $(FIELD_B)<>"VALUE Z", $(FIELD_B)="NEW_VALUE_1", ETC))...
there is one issue using only email address. if there are generic emails, for example, president@'xxx'.edu or others, you could have multiple returns (for example, an executive assistant could have that email address as well as they monitor that emai...
