Formula #ERROR

[javisantacata]

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.

[Pascal_Gallais- · Accepted solution]

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