Flip row and columns

Options

TVP ALAN

TVP ALAN ✭✭✭

05/24/24 in Smartsheet Basics

When create a form with a lot of questions the sheet will be very large ?

Do we have the possibility to flip the questions and the answers…. so the sheet will be more easy to read ..

Brgds

alan

0 ·

Answers

Brian_Richardson Overachievers Alumni

05/24/24

Not without a lot of work. Sorry Alan.
If you need to flip the rows and columns, see my post on how to setup an Unpivot.
https://community.smartsheet.com/discussion/98688/challenge-unpivot-financial-data-reverse-pivot

BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM
SEATTLE WA, USA
IRON MOUNTAIN
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Attachments not included in email alerts (automation)
Is anyone else experiencing this issue? When I set up an automation to alert someone by email and choose the “link to sheet and specific fields” option, I do make sure to include the attachment field in the selected fields. However, even though the row has an attachment, it doesn’t carry over into the email. That said,…
Are Automations the BEST WAY to clear a sheet before a Bridge Workflow is run?
I've seen various ideas on how to clear a sheet using bridge before beginning a workflow. However, could it be as simple as this?: Add a checkbox column such as "Delete Row" Use Bridge to change all rows to be removed using an "update sheet" in Bridge. Use automation to move rows out when the row is checked instead of a…
Issue with Dashboards Showing Percentages with Unwanted Decimals
We are having an issue with the way Dashboards are now showing Percentages (if the source value was an integer). It sounds like Smartsheet implemented a silent update to Dashboards, but as part of the update, the behavior of some of the widgets changed. We have a Project Management workspace template, that includes a…

woman with hands out and open

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video<