-
Merged: Enhanced Report and Sheet Filters for Dates
This discussion has been merged.
-
Adjust Column Size in Metric Widget
Please give us the ability to change the column size within metric widgets. It is very difficult to get good spacing with a forced 50/50 column size. Couple examples here: If I could adjust the right-side column size, I could have a perfect metric widget. Please Please 🙏
-
Smartsheet Icons for Flowcharts
Hi all, I'm trying to make a simple flowchart explaining how a solution I built works. Smartsheet does it this way, and I'd like to replicate it: Does anyone know where to get these icons?
-
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 %…