Sign in to join the conversation:
Is there a way how the charts in a dashboard can be updated automatically as one add new rows to a database?
Thank you.
Hi yes all the charts update dynamically from the data they are charting so if you are counting rows in a sheet with your graph then when you add more rows they will update (you have to do a manual refresh on the dashboard or set it to auto-refresh every few minutes).
Mick
I don't think that answers the question.
If I have a column with numbers
234527111154
and add a new row,
76
the chart was setup for 5 rows and now should be 6.
This might be possible with Reports, but with the recent delays in Reporting, I can not test to be sure.
Craig
It (my interpretation of the OP's question) is possible with Reports.
Thanks for asking, this led me to a solution I had missed before.
Hi, the bit I missed was using CountIFs to capture all row data then chart from that. That way all row data gets used by the Charts.
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…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
