-
Count if date is in the past
Hi All, I am looking for a solution to a problem, I am trying to pull together a chart for a dashboard, displaying the number of overdue documents under review we have - the sheet is set up as below, and I have set up a 'metric sheet' however I am not sure this is the best solution. I have been using this =COUNTIFS({Master…
-
IFERROR INDEX COLLECT if greater than 0 issue
I am trying to collect from a separate sheet the counts of holds if the site matches and if the count of holds is greater than 0. I am trying to collect the Count of holds if the site matches if the count of holds is greater than 0. Can someone please help me try to collect this. I tried below and did not work:…
-
Duplicate Data combined for distinction
I was reading this help and it has some parts I need and noticed it referenced a sheet that no longer exists. https://community.smartsheet.com/discussion/69259/formula-to-pull-data-from-one-column-and-combine-duplicates What I am looking for to get going and just hit a dead end after reading in here for the last few hours.…
-
Retrieving previous status to show on Dashboard
I have a Status Update worksheet. And what I'm trying to do is show the current update on a project dashboard and want to show the previous update to the dashboard as well. How can I automate this so it automatically will update my dashboard whenever I make updates to the Status Update worksheet?
-
Dashboard Improvements for Visual Communication
One of my objectives for organizational development is to promote the utilization of SmartSheet as a visual communication platform to bring in all our data sets and show this in a visually appealing dashboard. Some improvements that I think would be beneficial for some users would be things like Flip Cards (text and image…
-
Merged: Ability to Embed Dynamic View Into Other Sites
This discussion has been merged.
-
Use Reports to create graphs on Dashboards
I think with the extreme power of reporting on smartsheets and being able to get all the data you want in one place from multiple sheets, you should be able to link the report to create a graph rather just embedding the report into your dashboard. You can do both the report embedded but create a graph with the data as well.
-
how do I add a calendar view in a Dashboard?
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them to have any any interaction, just see it as a reference. Is this possible? Thank you. Jef
-
Help with calculated columns / data manipulation to display in dashboards
It's quite a long one, so bear with me! We have a process where Program Managers provide a status update (among other things) on their programs every 2 weeks (On Track, At Risk, Severe Risk etc.) A program could be sitting at "At Risk" for a 12 months, and this is what I want to display on my dashboard. I want to know what…
-
placing multiple report widgets on a dashboard
how can I place multiple report wigdets on a dashboard at the same time? can you really only select one report at a time? that also means i have to click through the whole folder hierarchy each time? i hope there is a faster way? thanks for all tips
