Hi everyone! I've been stuck on finding a solution for populating jurisdiction-specific languagewithout needing to ask a question outside of the Countrerparty's Address field being use. I definitely need fresh eyes on this, I keep going in circles! Anyone able to help? 🙏
What I Need: I need specific language added to a contract when the counterparty is located in France.
What I Want: I want to create a condition (or formula?) that would use the Country entered at the Counterparty's Address field rather than me needing to create a seperate field asking for the counterparty's country.
Problem: The forumla I created (Equals("[CounterpartyAddress]","France"))isn't adding the conditional language when the address is located in France.