-
Number of weeks countdown from today to start date
Hi! I've searched other threads and haven't found a formula that works for me. I'm trying to create a countdown in weeks for events on a sheet to pull into a dashboard. I want to display the number of weeks from today's date to the event start date. I tried this formula: =WEEKNUMBER(TODAY()) - WEEKNUMBER([Start Date]12)…
-
Help for Status Change and Tracking
I am trying to create dashboard widgets from data that I am tracking. For this widget I am wanting to have a graph show the number of people in each status section I have listed: "Not Started", "In Progress" and "Completed". Each employee has an individual sheet with tasks listed along with corresponding start/end dates,…
-
Printing embedded sheet within dashboard minimised
When embedding a sheet within a dashboard, this appears normal and stretched across the page. However, when printing the dashboard which we do from time to time to include in board papers, the embedded item becomes minimised. Currently there is no work around other than printing it as an individual sheet and having it as…
-
How to Setup COUNT/COUNTIFS formulas
I manage the educational benefits at my job and am trying to find totals of how many dependents, drivers, and office employees participate in the benefit. This is how I've been setting up my formulas. Yet when we cross reference with Excel the total number is off. =COUNT(DISTINCT(COLLECT([Employee ID/Driver Code]:[Employee…
-
Building a Client-Facing Portal in Smartsheet. Workapps?
Hi Smartsheet Community, I am trying to figure out what the best avenue/ tools within smartsheets are to build out a published portal that is dedicated to our customers. Some background: My company generates utility-scale renewable energy projects from scratch. Our business model is to develop these projects over time…
-
3D Bubble Chart in SmartSheets
Hi Team, I am looking to recreate this 3D Bubble Chart in SmartSheets. Is this feature available? I would need the option to plot 3 variables. Please advise. X = Benefit Y = Effort Z = Size of the bubble Regards Sowmya
-
Automatically Creating Dashboards from Form Submissions: Is it Possible?
Hello Smartsheet Community, I'm currently leveraging forms to collect QBR feedback from each of our change managers. Each form submission results in a new row of data within my sheet. I have a vision to create individual dashboards based on the data from each of these rows. Essentially, every time a form is populated, I'd…
-
Sheets, Reports, Dashboards and Workspaces now tied to Smartsheet Plans instead of Individual users!
Hi Community, Today, we’re excited to announce that sheets, reports, dashboards, and workspaces are no longer tied to individual users but instead they are tied to Plans. This means that as users change roles within organizations, leave organizations, or have their licenses removed, business workflows and processes built…
-
"Ticker Tape" Feature on Dashboards
Could a "ticker tape" feature be added to dashboards so that we could add important news, announcements, callouts, etc., that stream across the top or bottom of a given dashboard?
-
Publishing a dashboard, "owners account" definition?
My company has an Enterprise account. I am the owner of dashboard in question, the workspace that the dashboard is in, but I am not the Enterprise account "owner". So my question is, who exactly are the users in the owners account? Do they have to be specifically shared by the admin/owner of the Enterprise account, or just…
