-
Dashboard - Graph of Report Data Over Time?
I'm struggling to create something that seems simple at face value. The sheet "Animals" is a ledger with the following columns: Date, Animal Type, Breed, Count 2/4, Dog, Pomeranian, 2 2/5. Dog, Pomeranian, 3 Each day a new line is added via a form for each unique animal type and breed, and we count all animals every single…
-
Stacked Bar Chart with Percentages
Hi There! I am trying to track and present progress on key milestones made by multiple countries to share with our donor. I want to be able to show the average percentage completed overall for the milestone, but comprised of that show the individual country-level progress. When I try to stack the bar chart of % complete,…
-
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…
