-
COUNTIFS formula across sheets
Hi all I've been using Sheet Summary's to calculate some data which seems to work quite well. For instance this is an example of a Summary that is working fine. (Its an ISO27001 audit tracker sheet) =COUNTIFS(Finding:Finding, "Opportunity for Improvement", Status:Status, <>"COMPLETE", [Agreed closure date]:[Agreed closure…
-
What Smartsheet templates are you using for clinical trial tracking?
Hey guys. Currently, I’m in clinical operations. I got a bunch of Phase II & III clinical trials in Smartsheet. We moved from Excel a few months back and still don't know the best way to set things up! The main difficulties I encounter are as follows: Tracking site activation in multiple states it's too dark Enrolling…
-
Edit Access for Some, View Only for Most
I have a large master sheet that I do not want anyone to have access to except the small team of admins. Is there a way for everyone in a dept to see the projects their dept are involved in (this is defined by a column), but only the PM can make edits to it? Bonus points if we can sort by "Status" then by "Kick-Off Date".…
-
Click-Through Capabilities for Smartsheet Calendar
When publishing a calendar from the Smartsheet Calendar widget to a dashboard, users can still slick through to a calendar list via the header in the calendar. There should be a way to "lock" the calendar view to a published dashboard that prevents users from clicking-through to other areas. This "locked" calendar should…
-
WorkApps person/gear icon
What does the person/gear icon mean when you add someone to a WorkApps Role? Is this an indication that they have a license?
-
Portfolio Gate Reviews
I have 165 projects in the portfolio, each with 5 gates and ~120 steps in a project. As an example if a project has successfully passed gates 1&2 and is coming up on gate 3 review, I want to be able to see the rollup at the portfolio then "zoom in" to see the project plan details for a specific project and gate 3. With my…
-
Count % Completion of Checked Items by Each Sub Project
Good morning Smartsheet Community, I am trying to put together a grid that captures the percentages complete broken down by individual areas of a project. Below are the variables I am trying to capture Percentages To Capture Power Installation % Data Installation % Millwork Completion % Configuration % Installation %…
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
Dynamic Dashboard Filters
I would like to add two dynamic filters as a widget within my Dashboard to define a date range (start and end date) which would then return a count value to that same Dashboard. I have been searching for answers but am not coming up with the solution I'm looking for. What is the cleanest way to configure this?
-
Sorting Columns in Report Widget in Dashboards
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.