I'm trying to figure out the best way to automate a formula specific to the parent tasks and keep the existing children formula in place. The goal is for the user to be able to add more parent/child t…
I'm working on a formula for project allocation. I'm extracting my information from two columns in another sheet, master tracker. The columns from the master tracker are Status and Project Leads. In t…
I have two sheets. Sheet A is a rate sheet with the columns: CEB, Client Name, Client Engagement Name, Engagement Resource, Engagement Rate. Sheet B is my weekly billable time report with the columns:…
Hello, I am trying to figure out how to put the following into a formula: If values in any child rows include "In Progress" then populate parent as "In Progress", otherwise... If values in child rows …
Hi all, I need some help with a formula which I believe I almost crack but I don't know what I'm still missing here, I want to flag overlapping tasks across multiple days and times, as you can see bel…
Hi! I'm calculating the averaged RYG in parent rows that's tied to our Status column. Until the status changes to something other than "Not Started", the parent row displays #DIVIDE BY ZERO. I'm tryin…
Looking to express the following: If [ID#] in sheet A is equal to [ID#@Row] (in sheet B), AND [Progress] in sheet A is between 90 and 100, show "Published" in [Progress] in sheet B, If [Progress] in s…
I have done formula on column 3 and 4 if column 3 returns yes and column 4 is blank, the status will return from column 3 but if column 4 has yes in it, the status will return from column 4 ignoring w…
Hello! I'm trying to create a formula that will generate a weighted sum total across a couple of criteria columns after each column has been assigned a score. Each of the columns will have a drop down…
I made typo in one of my formulas but it still returned the desired result. I want to understand so I don't end up with unintended results down the line. My goal is to extract the data that follows "S…
