I keep trying different variations and can't find it right: The formula that I used which is close would be =VLOOKUP([Item ID Number]@row, {Adult Sponsor List Range 1}, 3, false). Sheet 1: giving tree…
An example would be to have a "Team Sheet" that has a column for "Team Dept." and another column for "Team members" that is a contact list type. In another sheet called the "Project Sheet," We'd have …
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…
