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

Wrap Text
How do I wrap text within a cell?
Dollar amounts in a form
I am trying to require a form field to only populate a number to display in a dollar format. I can only see the requirement of a number, but not an actual dollar amount. Is this possible in a form?
Copied Smarsheet as new, now Conditional Formatting will not work at all
I copied a Smartsheet and changed some of the column headers. I deleted all the Conditional Formatting because it no longer applied. Then when I set up new Conditional Formatting, very simple - if this cell says YES, make the row green - it will not work at all.

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