Data validity, help with expression

I need to prevent users from changing an assigned location without making sure status is correct.

Two fields: evac center location and appstatus.

I want to say that if the location is choice a, choice b, or choice c then app status should equal “complete - accepted hospital” and if location is choice d or choice e then app status should equal “complete - accepted evac center”.

Now there are other app statuses for archived and deceased where location no longer matters.

  1. not sure which of the two fields the valid if expression goes and

  2. not sure how to write the expression.

I tried and bunch of IF statements but they didnt work.

Help is appreciated. Thanks

0 9 366
9 REPLIES 9
Top Labels in this Space