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

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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