I have a series of projects listed in a sheet (Sheet 1), each of the projects has a deliverable name. For each deliverable name I have a Symbol, a Checkbox, a Percent Complete, and the Person Accounta…
I have a series deliverables reference from another sheet (sheet 1). In this sheet (sheet 2) I list those deliverables under an objective and I want to rate the entire objective based on the highest r…
I have 3 columns of data: Column 1 is a location (for example 101, 102, 201, 202) Column 2 is a date (for example 12/1/2023, 12/2/2023) Column 3 is a duplicate transaction labeled as D or if not a dup…
thank you in advance. how do you write a formula that looks at another sheet for a condition present in one column and then look at another column in that sheet to see if it has a flag? appreciate you…
how do I do this? I have the below which grabs the count correctly for anything less than 100% and <= today's date, but I want to grab the min and max date. =COUNTIFS({Estimating Percentage}, <1, {Est…
I have the following setup: An Individual Project (Individual) A Dashboard Rolling Up Projects Assigned to an Individual (Program) A Dashboard Rolling Up All Projects (Portfolio) Each of the Individua…