In my project sheet, I have a Task Complete tick box. I would like a date to be placed in the Reminder Date column if the box is not ticked by the Estimated Delivery Date. Is this possible?
In my project sheet I have checked boxes and flag. I would like to include them in my formulas. Example: If the box is unchecked by X date then the X date will appear in a reminder column.
I'm trying to link cells pulled from other sheets called {Projects Info 2018 CG1-5,10} & ,{Projects Info 2018 CG 6-9}. When the column called "project" in my sheet is the same as in {Projects Info 201…
Hello, Is there anyway to have a project task list that is updated from multiple project task list sheet? We are looking to have a master roll up of the Project Milestones without including all the ta…
Hi, I would like to change a symbol cell based on the status of a predecessor completion status i.e. "If a predecessor completion status is 100% then the status of this raw should change".
I would like to create a master project rollup to track projects, and do not want to set up cell linking every time a new project is added. To this end can we create a dynamic lookup so all the user h…
Hi, I am trying to create an element of capacity planning for the company i work for, and am having issues with the start date and finish date. I have a master production planning sheet which has a ba…
My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range f…
I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet. We use these set as a template to save an copy to a new work…