-
Dashboard Line Chart - Automatically Update
I have a Dashboard created with a Line Chart in place that plots simple data points 'as of' a certain date. I have a Data Shuttle that updates the source sheet each Friday with a new data point. Is there a way to get the Line Chart to automatically recognize that a new row / data point was added to the source sheet?…
-
Summary across sheets
I have two work plans with folks assigned to tasks and want to be able to see how many tasks on each sheet the person has assigned to them. For example (not in terms of formatting) Person A: Sheet X=# | Sheet Y =# Person B: Sheet X=# | Sheet Y =# I have a report grouped by person that has both sheets feeding into it but…
-
Optionally show item in dashboard
-
Pie chart not showing actually percent complete
@Paul Newcome Hi Paul - I found your solution for displaying appropriate percentage for pie charts in Dashboard. You had suggested entering a "helper column" =1 - [Percent Complete]@row. Your recommendation worked for one of my pies....but not for the others.....I am only referencing the two percentages so I am confused…
-
permanent link to attachment in the latest version
Hi is it possible to set a permanent link in a sight to open/downlaod an attachment in a sheet (actual version)? I want to provide useres a link to open a template out of a sight. This could work with a URL Link ... so the questin is if it is possible to set such a URL to an attachment in any sheet. Many Thanks Peter
-
NEW - Multi-Corner Dashboard Widget Resizing
Hi Community! Good news! While editing a dashboard, you can now grab any corner of a dashboard widget to change its size. This update should help save you time and make it easier to build and modify dashboards. This feature is available for Trial, Pro, Business and Enterprise plans. Learn more about resizing and editing…
-
Dashboard with date range parameter but allow multiple users to view their own dashboard with differ
Hello. I made a Smartsheet dashboard which allows them to select a "From" date and a "To" date and allow a user to view the dashboard within that time frame. However, I am wondering if there's a way for more than one user to view this dashboard with their own date range without bothering others' date range when they view…
-
Populate multiple metric sheets with cross-sheet formula(s)
I'm looking to improve how I've set up several metric sheets to make sure data is staying up-to-date. The components of the workflow are here: Sheet 1 = This is the reference sheet that is used in reporting. Our billing department uses it to track claims. It's a basic sheet with a simple automation that moves rows to an…
-
Counting the number of items due in the next six months from today's date
Hi, I am struggling to find a formula that can count the number of items (each row represents a task/project) that are due in the next six months from TODAY (the date of viewing). At the moment the below formula is incorrect ... =COUNTIF([Target Closure Date]:[Target Closure Date], IFERROR(MONTH(@cell), TODAY(MONTH(+6))))…
-
Dashboard > Shortcut Widget | Editing a Shortcut widget not working.
Editing and existing widget does not show the current link/url and title. The fields shows blank, and updating them does work. I know its a minor thing and we can just create a new widget, but im just throwing it out there.
