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.
Solved
Formula #ERROR
+6Best answer by Pascal_Gallais-
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
+21Hello,
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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.