When I copy columns from SmartSheet & paste in Excel, it takes all the columns & merges them into a single column in Excel.
It wasn't doing this 5 minutes ago. Any idea what went wrong & how to correct this?
I just tried a test copy / paste of several columns and it is pasting correctly into Excel (I copied 3 columns and it pasted as 3 columns). So it sounds like something on your end. Perhaps an accidental setting change? have you tried loging out, shutting down the app, and restarting?
I don't want the entire column. I just want a selection of data from within the Smartsheet. For example: I can copy from Column A (Rows 1-10) in SS & paste into Column A in Excel. But if I try to copy from Columns A, B & C (Rows 1-10) in SS & paste into Excel, it will shove all of that data in Column A, instead of pasting into Columns A, B, & C.
I can't see any format changes in either SS or Excel, and getting the same result copying from multiple different worksheets in SS to either fresh Excel workbooks or previously formatted workbooks.
It doesn't matter if the cell is dropdown or parent/child, I cannot get a scenario where this is pasting in the same manner I am copying.
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
Hello, I have this formula to return the number of items that have not been ordered. The formula works perfectly so I want to make it a column formula but get the below error. =COUNTM(PPE10) + COUNTM(Tooling@row) + COUNTM(Consumables@row) + COUNTM([QEW LOTO]@row) + COUNTM([Rigging/Basket Access]@row) + COUNTM(Fillers@row)…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.