The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Re: Formula #ERROR
I am trying to extract the first 6 digits from a rollup so that the main column is automatically filled with the resulting ID, but when I use this formula, I get #ERROR in the fields.
Accepted Solutions
Hello,
Problem comes from the fact that "Rollup" field is of type Array and not String as expected from the "Left" function.
You should write your formula as such to solve this issue:
To get expected result:
Regards,
Pascal
Hello,
Problem comes from the fact that "Rollup" field is of type Array and not String as expected from the "Left" function.
You should write your formula as such to solve this issue:
To get expected result:
Regards,
Pascal
