Sign in to join the conversation:
Hi
The new dashboard charts are a great addition to Smartsheet. Will you be introducing a way of charting against reports as well as sheets? Or is this functionality out there and I am not aware of it?
Many thanks
Vicky,
Charting against Reports is in the feature enhancement list and on our future product roadmap.
Thanks
Sasan
We just released the new capability to select data from your Report. You can now select a Report you have access to and then in the chart preview panel you will find a new button called "Select Columns". You can then select specific columns in your Report you want to chart against. Hope this help.
Hi Sasan,
When I am in chart preview I do not see a "Select Columns" button. It just says the report will be charted in its entirety and when I proceed there is a data error.
Thanks,
J.C.
J.C.,
Do you have numeric values in any of your report columns to the right side of your first column? If there are no numeric values in any column, the chart would not know what to plot and therefore, the message and Select Column is deactivated. If that's not the issue, please attach a screenshot of your report data range and chart preview panel.
I'm having a similar issue but curious why I need a number in a report when I don't need it in a sheet? I have chart by product / status using a sheet - but that requires a lot of cell linking (tried other options but most require some maintenance that for me would be more painful than cell linking.
So if I can just replace the cell linking by using a report - problem solved. But have tried 2 reports, moving primary column out of the way to get an axis value in 1st row, but nothing works same as the sheet.
Assistance would be appreciated
Tere,
Would you please provide examples of your sheet and report data source, the range you are selecting for the chart and the respective charts behavior for each? Examples will go a long way in understanding the situation, providing suggestions or troubleshoot.
I've tried 2 ways:
Report - all columns - selected cells (same as sheet) using the select column, I only get 1 value to plot. So I limited the report to see that helped, which is what I'm showing in picture. If I select ALL columns which is default, I get 'task' as the legend item, tried moving around the columns to see if that helped, I got a different value now Project as example, but only 1 ever plots and there are about 20 in the list. Tried selecting only 2 columns, then I get an error message (shown in pic)
Never mind - I'm an idiot LOL, I did my 1st chart off of a formula sheet which is built by project/status - dashboard references it, not the master sheet. So what I have to figure out is formula to multiple sheets (yuck) or formula to report (which isn't possible it seems) - back to drawing board
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
