-
Truncate currency data labels on dashboard widgets?
Hello everyone, I have a dashboard where monthly financial and fundraising info is displayed in line charts. The time frame displayed is a calendar year, so for the first few months of the year the chart is fine. After a few months however, the data labels - some for 7- and 8- figure amounts - start overlapping one…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Colors in Column Charts
All -- I am trying to create different colored columns in my chart, but I'm not getting the option: ... unless I deselect "Switch Rows and Columns," but then I lose the column headers on my chart: The Help and Learning Center is woefully unhelpful on this question: That's all good and fine, but is there any way to choose…
-
Why can't charts widget select columns from sheets?
I'm setting up standard line graphs through using the charts widget on a dashboard. I am pulling the source data from sheets which get updated once a quarter with information I would like added to the report automatically. It seems that I can only select a data range and not select the entire columns so that the graphs…
-
Why does my dashboard widget always end at 120%? (see photo attached)
I am trying to develop a dashboard column widget which shows the progress of items by percentage. For some reason on the graph it is showing 0% - 120% instead of finishing at 100% - see image attached. How do I fix this?
-
Typing Minutes of meetings directly in dashbord
HI all We do our meeting with a dashboard a couple times a week. We have a chart that shows the development of all our current projects and products. Sometimes we need to write notes to the projects, (which we have a grid for in the project folder), but it would be great if it was possible to write notes directly into that…
-
How can a contact field by aggregated to show a count?
I have a list of projects and each project has an individual as a contact. An individual could be listed for multiple projects. I'd like to chart to reflect how many projects each individual is responsible for. The trouble I'm encountering is that the report doesn't allow me to summarize on the contact list field and the…
-
Project Tracking & Rollup Dashboard Question
Help! I'm new to Smartsheet so this may be a dumb question. On the dashboard template "Project Tracking & Rollup" why doesn't "Percent Complete" (16%) under Project information) match the "Complete" status (1%) on "Tasks by Status" widget? Confusing ... Thanks!!!!!!
-
How do I pull in a table into a Dashboard?
I linked a form to a sheet that has the data that I want to pull into a dashboard. How do I create a table from that data into a Dashboard and be able to format it as needed.
-
Changing ownership makes Chart Widgets turn to Missing Source
As the Smartsheet Admin, I create most of the Sheets, Reports, and Dashboards for the Executive team. When we transfer ownership of all Sheets, Reports, and Dashboards to the Executives, their Dashboard Chart Widgets all state "Source Missing". Smartsheet's Help Desk provided this response: "... you may need to transfer…
