Flip row and columns

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

Sending Alert Email based on Contact Column without sharing sheet
I would like to create an Automation to send an email regularly to recipients that are in a Contact column based on some criteria. After setting up the Alert Email it says that I must share the sheet with these people in order for them to receive it. The email contains no information from the sheet other than getting their…
Removing Duplicates while also adding together values from other columns
I have a bit of a complex situation. My company uses SAP for purchasing and we pull an open order report weekly to keep track of each of the buyers orders and delivery dates. I've recently set up a Data Shuttle so we can transition from manually editing the report in Excel to a more fully automated report in Smartsheet.…
Workflow Notifications (Alerts)
The Manufacturing department in my company created a sheet to track requests related to downtime. I was asked to set up several workflows. One of these workflows is to notify the Head of Manufacturing and his direct reports whenever a new request has been submitted or the status of a record changes. These alerts are sent…

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