-
Setting up a Monthly 'Check In' Safety Audit
I've tried this a few different ways and keep hitting a bit of a wall. Has anyone created a Monthly Check In for Safety for multiple Sites of a business? The idea would be every month someone at one of the sites can submit this 'audit' and we'd track that it has been done each month. The 'checks' at each site would be the…
-
Change chart series labels
It would help if we could change the names of chart series labels for summarized data like sums and/or counts. Right now I'm having to explain the difference in labeling on my dashboard.
-
I'm embarrassed to ask: How do you write an API
I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have: Source Sheets > Report > Helper Sheet As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question. Here's what I know…
-
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
-
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
-
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
-
Selected Data Cannot be charted
It does not matter which data I select, I am getting the error of Selected data cannot be charted. I even tried reusing a report that is producing a chart on a different dashboard, but I am unable to create new charts in a dashboard. Anyone have any ideas as to why?
-
Native Secondary Axis & Mixed Charting
Problem: Current Limitations Scale Conflicts: Currently, users cannot easily plot two data series with vastly different scales (e.g., "Budget" in millions vs. "% Complete" in decimals) on the same chart; the smaller metric becomes invisible. Complex Workarounds: Users are forced to create "Helper Columns" (to manually…
-
Changing single asset access on new membership model
Hi there - We recently transferred over to the new membership model. In the past, I could change a user's access on a single item in a workspace without changing the workspace permissions. For example, a user could be an Editor on a report but overall have Viewer access to the workspace. However, now I am finding that I…
-
Incremental Baselines & Dynamic Baseline Linking
Problem: Current Limitations Destructive Updates: Currently, snapping a baseline is a global action for the entire sheet. There is no way to baseline newly added scope (new tasks) without overwriting and erasing the historical variance data of the existing tasks. Manual Data Entry: Users are forced to manually copy/paste…