-
Is there a way to build and cycle through dashboards for a number of similar projects?
Hi, I'm new to Smartsheet so maybe there's a simple way to do this, but I don't know how. We have about 50 projects that we need dashboards for. They will all be very similar, each containing some basic info about the project, team members, a few tasks, dates, and milestones. One project may have a few more tasks (and…
-
Why is my embedded web content unable to be seen by other users?
Within my team's workspace, I have created various sheets and reports that are being rolled into a single dashboard. One of the reports I created in this workspace is best suited for a "card view" report. For context, this report organizes various project cards by which phase they are currently in. For me to have this card…
-
Guage Chart or Speedometer Charts
I couldn't find a gauge chart option in Chart widgets, any idea if it is available or any work around? It is strange - as this is very basic chart other apps/ Software provided for their Dash boards. Seems Customization is not an option in Smartsheet, I mean ever Excell can create a gauge chart.
-
Option to remove zeros from Scatter Charts
When using a scatter chart any value of 0 is plotted on the axis. It would be great to have an option to toggle off displaying these values. It crowds the scatter plot with junk information. Here is a before and after example where I use a formula on the metrics sheet to change any zero values to null values. With 0 Values…
-
Issue with dates input in smartsheet dashboard
Hello i'm having an issue with dates input into smartsheet. the format should be in dd/mm/yy but it seems the backend is reading it in mm/dd/yy. so when i select a date like below it completely changes and also it prevents me from selecting days that are greater than 12. see pictures below for example. i select in the…
-
Referencing the Row Above in a Formula
Hi all! I am trying to create a formula that compares 2 values in the same column. One on the current row, to one on the row right above it. Every row represents a separate week, and I want to compare metrics from the current week, to last week, and based on the result (>,<,=) a symbol will appear. I found a post where…
-
CALENDAR - On Dashboard
Is there a way to display a live Outlook Calendar on the Dashboard? That's the ultimate Goal. If NOT, then I'd like to show a Live 1-Month View Calendar view with the Data of: 1) Contact and 2) Function to Perform (ex. Robert Smith - Refrig Install).. within the Block of a Date on a calendar - to allow more than one Job…
-
Dynamic View on a Dashboard
I embedded a Dynamic View on my Dashboard and it is coming through with random highlighting of the cells that is not on the Dynamic View or the source Sheet. I did not have this issue when I added a widget of the report before it was converted to Dynamic View. Is this typical behavior for Dynamic Views on a Dashboard?
-
Standard folder location when adding source data
Hi, Another 2 cents from me; When for example adding a Dashboard in a Folder I am working in, and after that adding a Widget in that said Dash (like a Chart); When clicking Add Data the standardfolder is top domain. It would be nice that the folder is actually the one I am working in in stead of having to open the folder…
-
Can Bridge Publish a Dashboard?
I'm working on a team member onboarding solution, and it needs to be automated as much as possible to avoid delays. Once a team member is approved for hire, I'll automatically spin up a new hire project in SCC, which includes a dashboard with resources for that specific new hire. I would love to have it populate the…
