I can't for the life of me figure out what is wrong with this formula. I am evaluating two choice selections from two separate fields to determine the answer for field 3 (which is also a choice/combobox) field. I run into this issue:
This is the formula:
=If(DataCardValue24.Selected.Value="Office of Research Admin" && DataCardValue147.Selected.Value="Cost Reimbursable Invoice","PROV Costs ORA","PROV Amount ORA")
I've also tried:
=If(And(DataCardValue24.Selected.Value="Office of Research Admin",DataCardValue147.Selected.Value="Cost Reimbursable
Invoice","PROV Costs ORA","PROV Amount ORA"))
