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

Returning txt in one cell depending on multiple check boxs with IF & AND
Hi, I'm trying to use IF & AND statements to return text to one cell depending on the condition of multiple check boxes. I have searched through the community posts and can't find the answer. Any help would be greatly appreciated. Below is what I have so that can't get to work. =IF(AND([Electric Disconnected]@row = 1,…
Formula error Unparseable
I've tried over and over again to correct this unparseable error without success. I've scanned the forum also. This is a pretty basic question I am unable to solve. Basically what I am trying to do is if the status ="Active New" then total the sum for the column 1st QTR 2024 In this forumla the 2 in bold are sheet…
Symbols Missing
Why do I have these three dots instead of the expanded column where I can see the other symbols for attachments and comments? How can I fix this?

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