I created a Travel Request Form. One of the approval steps is for budget approval. There are two people who can approve for budget, let's call them Jack and Jill. However, Jill only approves for *grant* account numbers, which start with 250, 251, 252, and 410. Any non-grant accounts need to be approved by Jack. There are several 'account number' fields on this form (for airfare, hotel, car rental, shuttle, parking, per diem...). In fact, any one of these (airfare...) can be split among 2 account numbers. It's possible that both Jack and Jill will both have to approve, and I'd like it to happen simultaneously.
I have a hidden field to determine who needs to sign. I'm working on the calculation on this field, but realizing my calculation will only work if only 1 of them need to approve. Plus, it would be nice to just put the 250, 251, 252, 410 in an array, and check each account number variable against that array.
=IF(
OR(
LEFT(Airfare_Acct_No_1,3)="250",
LEFT(Airfare_Acct_No_1,3)="251",
LEFT(Airfare_Acct_No_1,3)="252",
LEFT(Airfare_Acct_No_1,3)="410",
LEFT(Airfare_Acct_No_2,3)="250",
LEFT(Airfare_Acct_No_2,3)="251",
LEFT(Airfare_Acct_No_2,3)="252",
LEFT(Airfare_Acct_No_2,3)="410",
LEFT(Car_Rental_Acct_No_1,3)="250",
LEFT(Car_Rental_Acct_No_1,3)="251",
LEFT(Car_Rental_Acct_No_1,3)="252",
LEFT(Car_Rental_Acct_No_1,3)="410",
...
),"Jill","Jack")
Any suggestions?