Is it possible to create a chart without including the hidden data?
Anna,
The hidden data is still part of the range. Alternative interim options: move the hidden data to another place in the sheet or move/copy/cell link the data you want to chart to another part of the sheet(s) and coming soon in April timeframe you can select specific columns in the range to chart and therefore you can exclude columns.
Thanks
Sasan
Looking forward to this addition. I was going to suggest also, that you could create manual cell links to your data into a new sheet. And then make charts from that new sheet which is linking to just the data you want.
https://help.smartsheet.com/articles/861579-cell-linking
All,
We just released the new capability to select specific columns from your data range to chart against. After you have selected your data range, in the chart preview panel you will find a new button called "Select Columns". You can then select specific columns in your data range you want to chart against. Hope this help.
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…
