Sign in to join the conversation:
I have a huge data set and that need to be filtered owner-wise in my bar/pie chart. However, I do not see any filter option available. Please help me if someone is aware of this.
Vramesh,
Without seeing your data structure and intended outcome it's harder for us to provide guidance or solutions. In general, the chart widget needs a data structure that is already summarized or aggregated and in a form of a table. Once you have the table, you can chart and then your viewers while viewing the chart can filter the view by clicking on any legend items (see example table below). You can summarize/filter your huge data set in a Sheet (via formulas, vlookup, cell links) or via a Report. Then you can target either the table in the sheet as your data source for the chart or target a Report and specific columns. Hope this helps.
Sasan
Hi everyone, I’m experiencing an issue where all of my sheets have suddenly disappeared from my account. Here’s what I’ve already checked and tried: I’m logged in with the correct email address I’ve confirmed I’m in the correct region I’ve checked my Deleted Sheets folder I’ve tried logging in and out in all possible ways…
I am looking for a decision matrix, preferably weighted. Is there such a thing in Smartsheet currently today, or is this something that I have to build?
Is there a way to pull comments out of a proof and have them show up as a column on the main sheet? They don't come up in the conversation area, but they're on the activity log. I just don't want to overlook a comment on something if they don't tag me. I'm looking for any way to put a signal on the sheet that there's a…
