-
Sum Collect - not working on new blueprint sheets
I am trying to reference a source sheet on project specific sheets rolled up from a control center blue print. I am using Sum Collect to gather the sum of transactions based on Project number, cost code and category. The Sum Collect formula is working on some sheets, but not others. =IF(Summary@row = 1, "", IF(Children@row…
-
Control Center - Can optional templates be used with Automated Provisioning
We currently use Control Center "Automated Provisioning". Our deployment process is trigger off an "Approval" column in our intake sheet. Our "Project Toolkit" aka Source folder currently has 16 items(Sheets, Reports, Dashboards). We are looking to add some optional templates to our "Project Toolkit". We would like to…
-
View all global updates created by other program leads
I would like to be able to view all global updates created for our program, regardless of which program lead created the update. We are sharing workload and so need to be able to see what each other has done and be able to check each other's run logs for errors.
-
Update on Outbound Cell Link Indicators
On August 7th, 2022 we reduced the number of outbound cell link indicators a user can see on a sheet from 100,000 to 1,000. This change turned off the visual indicators (triangle in the bottom right corner of a cell). There is no functional impact to your sheets except for the removal of the visual indicator (triangle).…
-
Control Center Permissions for Provisioned Project
Hi, I have an issue where some of my projects are being provisioned and the project manager has admin permissions on the sheet. In the blueprint only the Lead and the and "Admin" slots have admin. The Project Creator does not have admin rights and I am unsure how it is picking the Project Manager from a contact list and…
-
Conditional Formatting Across Sheets
Hi, we have a Scheduling Sheet (with columns, wk 01, wk 02, wk 03, wk 04, etc). A Delivery Date column links into this sheet from another sheet. What we do at present is highlight the relevant week column based on the date in delivery date, so for example from Jan 2nd to Jan 8th is wk 01 this year. (See screenshot…
-
Auto provision SCC using optional templates
I am using optional templates in a blueprint and have them grouped. My question is, can I automate the project creations using options templates and based on a value on the intake sheet, certain templates are selected to be used? IE. If the column is named "Project Type" on the intake sheet. can that dictate which of the…
-
Global Update Troubleshooting
Hi I was hoping someone could help me with a Global Update Problem. I have created a Global Update for the Project Dashboards for a Control Center Solution. The Dashboards have all been updated, however, the links to the Project Dashboards in the Intake sheet are all corrupted. Is there an way to re-establish the link to…
-
Help with editing my control center - adding a hyperlink to the provisioning process.
Hello All, I would like to add a hyperlink into the job portfolio master upon the control center provision process. We already do this with a project dashboard, but I am not sure if can be done with more than one? Each project has a "warranty notes" sheet. With each provision, the warranty notes sheet is re-named to the…
-
Control Center: blueprint source folder to be able to contain more than 100 items
Hello, We recenlty received the error "Provisioning Status Error" while creating a workspace using control center. The reason given to us was "I advised that the error message you were presented with is presented when a blueprint source folder contains more than 100 items, and that we recommend keeping it under 75 items…
