This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
The TRIM function doesn’t seem to work when referencing a Lookup field in a Linked Record. Every time I try to trim the data that’s passed from a lookup in a linked record, my formulas return #Error. Here’s the formula at fault:
TRIM({AMID (from link...
Thanks for the response. I’m confused about why the lookup field is treated as an array when it seems like it’s just copying data from a cell attributed to another record. Shouldn’t it be treating that data the same as the original?
