-
Formula working for one data value but not another
Hi Community, I have a sheet that contains, among others, columns titled "Priority" and "Contract ID". Multiple rows can have the same Contract ID and the same Priority. Priority values are 1-2-3 and restricted to dropdown list values only. To collect the number of unique Contract IDs that are Priority "1", I have this…
-
How to create a day countdown from starting date
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
-
Managed vs Unmanaged Resources Utilization Reports
I have linked my Project Plans to Resource Management but the Utilization report in Resource Management is only showing me the Managed Resources and does not show me the Unmanaged Resources. Is there a way to get this Utilization report or view without having to buy Licenses for all these Resources who will not use the…
-
Automation of Weekly Updates
Hi all, I have a Smartsheet that I use to track multiple document requests for multiple clients. I need to provide updates to client contacts (sometimes more than one, and they may have more than one client connected, but the updates should be by client) that are connected to each client on a weekly basis. I'd love to…
-
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…
-
How to prevent entire Gantt timeline from shifting when updating activity dates? (Float reduction instead)
Hi everyone, I’m looking for some guidance on how Smartsheet handles float and dependencies in a Gantt project schedule. I’ve built a Gantt plan with several tasks linked through dependencies, and I can see the calculated float/slack between activities. When a small delay occurs on one activity, I update the start date to…
-
I am stuck in view mode but I have editor access level how can I be released from view mode and back to editing the sheet
Hello I share my sheet with a fellow member to add and do task to update this sheet they were editors to the sheet but something happen where now they can only view the sheet and can not in put any information to the sheet what I erase them from the group and updated the app but once he got access to the group again he…
-
Status reports
Has anyone figured out how to easily see overdue tasks in RM or how to pull a report? Side question: Are we any closer to have RM statuses sync to Smartsheet?
-
Mistakenly Cancelled my Business Plan
Hello good people. I cancelled my Business plan by mistake, before transferring ownership to other account. Now i have enrolled and paid again i still cant edit my workspace and sheet as they are on view only. Please help me on the way forward.
-
Sum values from child rows automatically with formula while allowing manual data entry into child row cells
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the child…