Two issues copying information from a report to a sheet
![Mel_Barnes](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have collated some information from all of our project plans to a report that I copy and paste into a separate sheet with additional calculations. The issues I have are:
1) On two or three lines related to one project plan, the information is in one column on the report, however, when I paste it into the sheet, it splits it into two separate columns, skewing the data in the remaining columns as they're all pushed over by one column.
2) Some of the figures that copy over are converting to % rather than a number. There is no obvious pattern to this and it just appears ad-hoc on certain lines.
Is there something specific I should be looking for in the sheet where I paste data? This is a system I have inherited and cannot go back to the person who set it up.
Many thanks
Mel
Answers
-
Hi, Mel,
The first point is probably related to copying from something Smartsheet identify as 2 fields. If you want to paste it to one column, you double-click to the field (cursor is inside field) and them you paste (Ctrl + V). This should insert everything into one field.
The second point is probably caused by different formatting. The field you try to paste is set up as Percentage so it changes the format to %. You can change it:
Best,
Beata
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives