I have a field that is the main/anchor link to another sheet. Based on an IF statement, I want to apply the following formula:
IF(A83.RAW=“Yes - Primary Borrower Individual”,A65,IF (A83.RAW= “Yes - Primary Borrower Company”,D65))
If the Primary Borrower is also the Primary Guarantor, Populate the Primary Guarantor ID# in the Linked Field.
It works perfectly with a non-linked field. Does anyone know if there is a work around for this?
Thanks!
Angie
Hi Angie, great question!
In general, it should be possible to use a combination of conditional formulas and the .RAW method on a Link field. While it’s quite rare for this setup not to work, issues can occasionally arise—usually due to minor misconfiguration.
Since each database is customized a bit differently, we’d recommend writing to us at support@ragic.com with the URL of a sample record showing the issue and the name of the field you’re working with. A brief description of how the formula isn’t behaving as expected would also be very helpful. That way, we can take a closer look and give you the most accurate guidance.
Looking forward to your email—we’re happy to assist further! 