Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi,
Is there a way to "flip" a sheet keeping links so that cloms become rows and rows become columns?
Hi Trym,
Unfortunately, as far as I know, it's not possible at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
A possible workaround might be to use Excel or similar.
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
What is the purpose for this? do you want to keep the original sheet? How large is the sheet? If the sheet isn't crazy big you can do this with just 2 index formulas
That said I highly recommend against this. Smartsheet is organized by data type, which is dependent on columns. The only way transposing a sheet could possibly work is if every column was the same data type, and then you would drastically restrict what you can do with the information. Also as rows are added for the original, columns would have to be added for the new set.
If you are interested in a solution, why not post a snap of your sheet so we can help you develop what you need.
The reason for doing this is to prep data collected in a Smartsheet to be read more easily into an analysis tool. You cannot do anything but simple analysis in this tool, but if you want to deep dive on tickets, etc. You need to be able to read the data into a tool in a more normalized design. Transpose would allow you to do this quickly.
Also - can you provide an example of the 2 Index Formulas?
I have build a email validation in my sheet where entered emails from a form are entered in a contact field. another field verify the address and validades using the following formula: =IF(FIND("@xxxxxxx.com", [Student eMail]@row) = 0, 0, 1) if the checkbox is triggered (=0), then the registration is valid, and the the…
I have a sheet that has a good number of automations that populate a field based on a value changing in a cell. These same automations have been working just fine since March up until today. All of a sudden they are being triggered when there is no change to the cells in question. If I click into the cell history, it…
Hi, I'm in the midst of a Smartsheet trial and would like to understand how to set up a project schedule that uses a firm delivery deadline. I understand I could use Start-to-Finish relationships, but this disallows use of many to one predecessor relationships (multiple tasks that are gated by a single work item). I would…
