-
Summary Fields for Dashboard based on dropdown values
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse engineering in that my requirement starts with the end product a dashboard. On this dashboard I wish to show, in graph format, how…
-
Skipping the middleman (calculation sheet)
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 currently utilize a separate sheet to perform =countifs contain functions to create visuals on a dashboard for various statistics based off the columns of information as it updates.…
-
Creating a widget for tracking the tasks for each member of a team
Hi. For the past few days, I've been trying to create a dashboard to track the tasks that each member of my team has. I learned that the best way to do this is to create a separate sheet where I used formulas to create a set of data and then use those to create charts in my dashboard. However, when I tried to use a formula…
-
Hyperlinks in sheet - Sheet embedded in a Dashboard - not appearing.
I have a source sheet that contains hyperlinks to reports. The source sheet is published as "Read Only - Full" The published sheet is embedded in a dashboard as a "Web Content Widget". None of the Hyperlinks are visible in the dashboard. When selecting the cell it displays cell info as shown below - The "Sheet" link has no…
-
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…
