Sign in to join the conversation:
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.
Has anyone had an issue where collaborators have lost their editor access to a worksheet? If so, how was it corrected? I have tried removing and resetting, clearing history cache, ensuring Publish:Read Only is OFF, etc. I could rteally use some help.
Like the title says. I wanted to send an email to all shared users of a sheet. I checked the box for 'cc myself' and it cc'd me on each individual email it sent to each user. I received hundreds of emails in seconds all with the same subject.
One of my team member is facing a repititive bug while entering comments on Smartsheet tracker. He has full permission on the tracker and doesnt have any internet or version issues. He is faccing this Smartsheet bug for some time where the comments are created after long set of empty pages and its hard to know how many…
