-
Hide Widgets from Published Dashboard view
It would be helpful to have the ability to hide a widget from view on a dashboard when published or when viewing as not the owner/admin. For example I have a standard template for projects and a widget may not be relevant now, but I will want to use it in the future as the project matures. I would want to move it to the…
-
Sharing Dashboards
I am relatively new SmartSheet user, less than 6 months. I have completed the Program Management Learning Path and worked to find an answer before coming to the community. I would like to share my dashboard with a client. They do not have a Smartsheet account. I can't find a way to share a dashboard without requiring the…
-
Gantt Chart Cuts Off in Dashboard View
I created a Gantt chart widget in a dashboard that pulls data from a report that in turn pulls that data from a sheet. The dashboard Gantt allows me to scroll both vertically and horizontally. All my rows can be seen with the list of tasks, but the columns that are supposed to show the full timeline cut off part way…
-
Why is my SUMIFS formula saying incorrect argument?
I'm working on a metrics sheet to power a dashboard. I want to sum our effort values for each of our chemists and each of our project categories. My ranges are: {MasterLead} : Column listing chemist on project {MasterEffort} : Column of effort values for each project {MasterRDCat} : Column of project categories I am trying…
-
Dashboard Widget Rich Text
It would be nice to have the ability to adjust the line spacing for Rich Text widgets. This will help with spacing and the overall visual effect of the dashboard
-
Can a duration column with dependencies not pull data from a created date column?
I have a sheet with a created date that is generated by the system upon submission of the project. I wanted to create a column that tracks the duration of the project from submission to delivery with dependencies, but when I click the drop-down under project settings it doesn't have that created date listed. Is there a way…
-
AVG Collect Formula Help
I am looking to add to the formula so that if {APD CI Tracker Range 5}, ="Pilot/ Implemented" the Dashboard reads "Pilot" OR if {APD CI Tracker Range 5}, ="Monitor/ Check" the dashboard reads "Monitor" and if {APD CI Tracker Range 5} is not Working, Pilot/ Implemented, or Monitor/ Check the Dashboard reads 0 Current…
-
Dashboards activity logs not showing other user activity
Team, I have multiple workspaces along with my coworkers. In one workspace, I have multiple dashboards. These dashboards are only showing my activity (I'm the owner) for views, updating, or downloads. Many other dashboards that I own in other work spaces are working properly showing dashboard views. I have also opened a…
-
Formula Help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (market) I thought it would be something like, but neither are working =SUMIFS(Campaign:Campaign, "Jazz", Market:Market, "AT",…
-
How do I update the Parent Cell so that anytime one of the candidates (listed in the Child Cells)...
is marked as "Hired" as the Status, it then doesn't count that row? For reference, see the first Parent Column "Accounting - 3 Openings" - however, there is only 1 opening that doesn't have the status as hired and it's not showing that...I tried to add conditional formatting to change the row to "Green" if status is Hired…
