JOIN() Formula Result - Producing Apostrophe in Copied Cell Data
The issue involves the usage of the JOIN() formula within SmartSheet, which is resulting in the inclusion of an unwanted apostrophe when the formula's output is copied to another sheet. The JOIN() function is designed to concatenate values, but in this scenario, the copied data is displaying an apostrophe that is not intended to be present. This issue is affecting the accuracy and formatting of the data when it is transferred between sheets, causing confusion and errors in data interpretation. I would like to resolve this problem so that the copied data retains its original format [just numbers] and does not introduce any extraneous characters like the unintended apostrophe.
I do not know how to fix this issue, I have checked formatting in the columns and there is no formatting, including the intake form it is selected to "number" only. I also have a ticket open with Smartsheet support but thought I would reach out to the community too.
In case anyone has ran into this issue before I would appreciate the insight or guidance, please.
Adriane
Best Answer
-
Fixed, needed to add "Value" before the formula to remove the apostrophe.
=VALUE(IFERROR(JOIN(DISTINCT(COLLECT([Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, [Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, <>""))), " "))
Adriane
Answers
-
Fixed, needed to add "Value" before the formula to remove the apostrophe.
=VALUE(IFERROR(JOIN(DISTINCT(COLLECT([Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, [Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, <>""))), " "))
Adriane
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives