
How can I achieve this?
3 answers
Hi Chris,
create 2 separate validation rules on opportunity object
one for making sure the Accounting System is populated when a new opportunity is created and the second for a text box to be completed when the value in the Accounting system is Other1. validation rule
ISBLANK(TEXT(Account.Accounting_System__c))
Please use the insert field button to select the field api name by navigating to opportunity name - account - accounting system
2. validation rule
AND(
Formula_Field_on_Opportunity__c = "Other",
ISBLANK(Text_Field__c)
)
or alternatively
AND(
TEXT(Account.Accounting_System__c) = "Other",
ISBLANK(Text_Field__c)
)