-
Is there a way to show those who will be out on PTO and what deliverables overlap with those dates?
My vision is to show calendar/widget of individuals that are out of the office/pto and which deliverables overlay with that time off.
-
Trying to create Chart widget based on report - but report not showing up as data source option
Hi there! I'm working on a dashboard on which I want to add a chart that displays a bar graph representing the data in a report (report is titled "Tasks in Next 8 Working Days, by Staff"). When I select the widget to create the report, I can select other reports in the workspace, but not this one. I'm baffled because I…
-
Sending Dashboard link to iPad users takes to home page but doesn't pull up dashboard in search
Hello community. When I send a dashboard link to my iPad users, it takes them to log in, they log in on the web (Assuming this is Safari) and then takes them to this view. In my view I see the Dashboard. When they try, there is no dashboard, the one thing they need doesn't appear. Even when I give it a unique name that's…
-
Making a Smartsheet Dashboard Public
I am working on a request to create a dashboard that can be viewed without logging in. I created the dashboard and set the access control to "Available to anyone with the link". However, it still requires users to log in using their Smartsheet credentials to view it. Is it possible that the System Administrator has…
-
Dashboard Error
I have shared a Dashboard with internal and external stakeholders, but they receive the following error when trying to view. I have shared it with them directly through Smartsheet and also with the direct link. What am I missing here? The individual's shared on the entire workspace do not have a problem accessing it. Do I…
-
Which formula do I need if I want to count issues assigned to 2 people that are counted for each ind
Hi everyone, I am fairly new to Smartsheet and this is my first question in this community! I have an Issue Tracker where issues can be assigned to multiple people. On one of the charts on my dashboard I am showing how many Issues are assigned to each individual. I have a formula that counts if an issue is assigned to 1…
-
Report and Dashboard
In my sheet, I have a column calculating the NETDAYS between two events. This column does not show up if I try to create a Summary Report. It only allows me to create a Row Report. In a dashboard, how can I use a half-pie graph to show the number NETDAYS greater than 37 and NETDAYS less than or equal to 37. I do have…
-
Automation for ever-changing database
The company I'm working for has a database that houses info for our external clients, the database is constantly being updated nearly daily, I want to create visuals on a dashboard for various statistics based off the columns of information. I used =countif and it worked well for some columns, but I quickly ran into an…
-
Dashboards and Reports
I'm building a Project Office (PMO) with 80 projects and looking to build a project dashboard for all 80 projects. We would need 4 reports per project (project summary info, project plan, issue/risk log, and project contact list). I'd rather not develop 320 reports (80 projects x 4 reports). Is there a way to do this more…
