-
Export formula to Excel
I am trying to export a budget sheet that has formulas to Excel and still have the ability to manipuate the numbers with the same formula, but it does not carry the formula with the export. Is there a way to preserve that formula during export? or is there some other way to export the data and keep access to the original…
-
Allocate tasks to non-existing team members
It's very important at the beginning of a project to put together a plan speculatively, to identify additional team members we might want to hire/contract work to. I don't seem to be able to do this - typically I write a placeholder for the new hire (e.g. 'PCB engineer 1'), and it would be great to see the resource…
-
Project Closure Checklist Template
Hi Community, before I go and create I was wondering if anyone has a good Project Closure Checklist Template they would be okay sharing please. Thanks Paul
-
Dashboards and Reports
I'm building a Project Office (PMO) with 80 projects and looking to build a project dashboard for all 80 projects. We would need 4 reports per project (project summary info, project plan, issue/risk log, and project contact list). I'd rather not develop 320 reports (80 projects x 4 reports). Is there a way to do this more…
-
Help to select a value based on row number
Hi all - I am trying to determine if a task is ready to start based on all of the predecessors being 100% complete. I have numerous tasks with more than 1 predecessor and I've parsed out all the predecessors into individual columns (pred_1, pred_2, etc) like this I'd like for the ready to start column to indicate yes, if…
-
Generate Documents & Control Center
I was hoping the saved mapping I created in my project plan within the template folder that control center uses to provision our projects would carry that saved mapping through to the provisioned project but unfortunately, it does not. Can you please enhance Control Center to bring over the PDF File so it can bring over…
-
I will pay someone to help me finish setting up my PMO template.
I've been working on this template for months for my department and I need to get it off the ground and working. I'm dead serious. I'll pay someone to help me get this completed in the next few days. I need someone who can work side by side, or just do it for me. I keep getting in my own way, I'll get so far, then have…
-
Trouble with Chrome Base web interface, no horizontal scroll
Hello - Is anyone else experiencing this? We have several google "chrome base" desktops, (just like a chrome book laptop, only a desktop).....while working from with in the chrome web browser, on the chrome base, we are not able to use the horizontal scroll in the grid view. We have to resort to selecting a cell, and using…
-
GANTT - Set Manual Start Date + Define Predecessors (for the same task)
// Current situation Currently, adding (1) manually a start date for a specific task AND (2) defining certain predecessors for the same task is not possible // Problem Description Let's imagine, we have the following two tasks to plan: Task 1: Starting at day 1 and a duration of 10 day Task 2: Starting at day 15 and a…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…