Sign in to join the conversation:
This is probably a simple question but I am trying to show weekly results over the past 4 months. This is fine obviously as a one-off data grab but I need the range to move every week automatically.
Can anyone help with this?
Can you provide some more details and possibly some screenshots of what you're working with and what you're trying to accomplish.
From what I gather from your post so far...
You cannot get a chart/graph (I am assuming in a dashboard?) to automatically change rows or columns. You would have to automate the data within the chart range selected or manually adjust the chart range.
Hi Paul,
I am not sure if this explains but a webform is submitted weekly and the data accumulates on a sheet week by week.
Management want to see the weekly results on a dashboard for the past 3-4 months so that they can compare trends. Obviously that date range moves every week and we don't want to have to change the date range manually every week to keep it up to date. Ideally we would like the set range to be automatically selected from 'Today' back '3 months'.
Trust this makes sense
It makes perfect sense. Unfortunately there is going to have to be manual work involved if you are plotting this on a chart type widget.
A few people (including myself) have put in product enhancement requests to be able to use reports for a chart widget on a dashboard. This would solve your particular issue.
https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?_ga=2.195178988.1717656072.1557144026-2072984282.1556800642
Hello Paul,
Thanks for your support!
Happy to (kinda) help.
Is there any feedback on this enhancement??
I am manually re-sorting my sheets ( I like the graphs to ascend or descend) and to capture set data.
Time consuming lol.. would love to streamline this one.
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…
