Ezra’s Profile

Community member since August 2018

About Me
take a guess.. probably right


I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to a cell in the project data sheet - then just grab the one


I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context.  These items are some of the things that would make


I have a master project plan where all tasks are listed.  I want to use this plan for any project and if a tasks is not needed I would like to keep the row but have a status of N/A. I would then like to have the % complete formula for the hierarchy to only calculate those rows that are needed so the


Hey folks, any idea how to pull this information onto another sheet horizontally?

Basically, I am trying to consolidate some project information as seen in the "Source" screenshot.

This particular sheet has the status for multiple items for the same project, but lists the same project on multiple


I see that there are 2 choices of 4 Status Colours: Green, Yellow, Red, Blue (or Gray).

Could we get an option for 5 Status Colours?

Blue - Not Started

Green - In Progress

Yellow - At Risk

Red - Behind Schedule

Gray - Completed


Firstly, yes - I know the Control Center sheets are not "templates" but I would want resourcing to be able to filter out the workspace or at least the folder used to spin up SCC projects.

Since I pre-load "assembly time" by assigning it to the genaric "Assembly" contact in ALL of the grouped gantt