Pivot: when more than 1 variables in columns?

arnedevet

arnedevet ✭

07/12/19 edited 12/09/19 in Smartsheet Basics

Current design of Pivots allows to have up to 4 variables in Pivot table rows, but only 1 in columns.

Will it be possible to enter more than 1 variable in columns? When?

Thank you

Tags:

Reports

0 ·

Comments

Andrée Starå ✭✭✭✭✭✭

07/12/19

Hi Arne,

Great idea! That would be a great addition to Smartsheet features.

Please submit an Enhancement Request when you have a moment.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
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…

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