Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar column with ranges based on a Status % column for a Project Tracker. Here is what I have: =IF([Status %]88 = 0, "Empty",…
I am having an issue with charts and my column colors. I am getting all the same color columns. I asked about this in the webinar last week and received this answer: "Colors are going to denote different comparative values (what's labeled in your legend). If you're not comparing more that one data set, you won't have…
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
Hi. I have a lot of sheets that I want to have shortcuts in a single shortcut widget but have limited space in our dashboard layout. Is there any way to have it show a scrollbar? Thanks!
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
I just want to tell everyone that with the additions of the chart widget, I am really loving our dashboards. I do wish the legends were editable and the selections didn't have to be side by side. I got around this by creating a second sheet and linking cells to the needed data. I could then create the labels I need and use…
I'm trying to create a pie chart using data from parent rows. I want to use first column as the labels and the corresponding (right) column with the numbers as the data. When trying to do so, I get the following message: "Please select a cell or range of cells that are next to each other. If your rows are collapsed, please…
Hi, Thank you so much for adding Charts to Sights! It appears as though the pie charts can only handle three data points, is this correct? Or am I possibly doing something wrong? Thank you!
Love the new chart widget in Sights. Thank you! Question: Why did you take away the custom colors for tabs in sheets and workspaces?
Via the Smartsheet Labs I've created a number of charts. I'd like to publish those into a Sight. I can't for the life of me figure out how. I'm hoping I'm missing something very basic.
