There is field : "Company Identifier "on Company object. Which having lookup relation with Item Object.
Now i am creating formula field on Item object with the below condition
If Company identifier is equal to "SMI" then on the formula field it should update "SMC" However, Company identifier is a Text field(External ID).
I created a formula using if condition but its showing me an error:
Error: Field SMI does not exist. Check spelling. I am wondering if we can use CASE function ?