-
Viewing team capacity over time
I am trying to see my team's capacity over multiple projects for each week to see who will have capacity to take on new projects. In the past I've done it by hand to look like this and I know in my mind the demands of each phase for a given project. This is quickly becoming unsustainable as we grow. I have a task list for…
-
Baseline vs Target Dates
Hi, In the PMO template we have both baseline and target dates. What is the difference between these? The target date seems redundant. Thanks
-
Hyperlink in a Request Update form
I am looking to see how I can insert a Hyperlink into a Request Update notification, Please find the attached screenshot.
-
PMO Efficiency - Workspaces and Automated Backups
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
-
#INCORRECT ARGUMENT SET on Index/Collect Formula
I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a…
-
Is there a way to move a dependant date further out without using lag?
I have a background of using MS Project where 'predecessors' are the equivalent of 'dependencies'. I have got used to smartsheets pretty quickly and for the most part get along with it but feel that there is a definite limitation when using dependencies as follows: In MS project if I have line 1 completing 28/11/23, I can…
-
Copy/ Paste Cells With Multiple Lines Doesn't Work
I've been digging through community for resolution to this issue, but I'm coming up empty. I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Currently, when I try to copy and paste these "multi-row" cells, they spill into separate cells instead…
-
Allow bulk deletion of projects in Control Center
Allow users to delete multiple projects in Control Center at the same time. Currently, we can only delete one project at a time. We have passed the recommended limit of 5,000 active and archived projects on a program and would like to delete some projects. The only delete option for active and/or archived projects is one…
-
Proposal Project Creation
We are slowly implementing Smartsheet from Trello and have a few questions on how to automate this to make it easier. We use a Form for our Coordinators to fill out information (RFP Name, due date, exceptions due...) so that this can be added automatically to a master list of RFPs for the year. With this, is it possible,…
-
If a value from Column A is found in Column B, can the occurrence be shown as "true".
Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be…