- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 27, 2024 01:10 AM
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! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 27, 2024 02:21 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 27, 2024 02:21 AM
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
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)