Skip to main content

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.

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

Reply


Terms & Conditions