- Combined Calendar Report - Can I Automate Labels?
Hello! I am a Project Manager trying to redesign how my company uses Smartsheet internally, and I'm hoping to use Smartsheet to replace several other tools we currently use. My current goal is to create a Dashboard where an individual on my team can see a calendar of all their tasks for the week or month, with multiple…
- Fourms
When adding a fourm to a dashboard, is it possible to clone/copy the dashboard and have the fourms copy with it? This one is hard to explain, but if you make a dashboard and you have 1 folder with 1 sheet and 5 reports in it you can copy it and all that data moves to the new folder etc... but it seems when you put a Fourm…
- Creating a report by task owner and RAG status
Hello Smart Sheet-ers, I am fairly new to SmartSheet so excuse me if this is breathtakingly simple. I need to create a report of the following in dashboard. I assume from using Sheet Summary. It needs to show Task Owner, then how many tasks that are RAG status red, yellow, green, blue. I'm using the below columns: So for…
- No scrollbar on metric widget in Dashboard
Hello, I'm struggling with the following problem. I have created a dashboard to report on a project. In this dashboard some metric widgets are added. The data is filled in by the project manager in the source file. Sometimes this contains lots of information and text, sometimes nothing. Is there a possibility to add a…
- Will Dashboard editing every include an 'undo' function?
Hi, it's very frustrating when editing text in a widget, that you can't undo. Hoping this is on a list of improvements. Thanks, Louis
- How do you represent your team contacts in a dashboard?
Hi There, I would like to add a widgit that shows team members, titles, and contact info but I am unsure how to do this. Is there a way to include contacts in a dashboard pull from Smartsheets?
- Struggling with creating charts on a Smartsheet dashboard
Hi - I am really struggling with the steps I need to take to convert a smartsheet with incoming form data into charts that reflect that data. I've gotten as far as creating sheet summary fields using COUNTIF formulas, then creating a report from those, then creating a simple bar chart from the report, but I can't figure…
- When downloading a template set, the dashboard doesn't seem to download with it.
I have been trying to download the Project Tracking and Rollup as well as the Project Schedule Management templates, which are both supposed to include pre-made dashboards, but the dashboards do not seem to download or populate. When I move the template set to a workspace, the dashboards still do not show, and when I…
- Connector Run Date: Pull into Dashboard?
Is there a way to pull in the the "Run Date" from Smartsheet Connector into a sheet/report/dashboard? I'd like to show the last time data was updated on a dashboard. The Auto-Number/ System: Modified (Date) is not reliable since it only shows the date/time of the run when data actually changes (Salesforce, in this case). I…
