-
Help using the NOT formula
Hello! I'm trying to write a summary formula to count how many projects have a Resourcing score of 8 or higher and the approval status is not "canceled." This is the current formula I'm attempting: =COUNTIF([PM Resourcing Score]:[PM Resourcing Score], >=8, AND(NOT(CONTAINS("Canceled by Specialist Team", [Approval…
-
Help with Index Formula
Hello! I am creating one master sheet for a variety of portfolio metrics (we currently don't have control center - working on that!) and am having trouble figuring out the best formula to populate the data I need for this one item. I want to calculate how many strategic projects vs. KTLO projects a team has for the…
-
Due in Days and conditional formatting question
I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to have it display no number once the task has been completed, or at least remove the red font once the "Status" column…
-
Sum totals from multi-select dropdown columns
I have two columns with multi-select dropdowns. I would like to add a column that will sum the totals based on what is selected in the two dropdowns. Here is what I am trying to accomplish: Cost List column: sandwich - $5.00; drink - $1.50 Optional Cost List column: icecream - $1.50; chips - $2.00 Total Cost to be charged:…
-
SUMIFS() formula showing unexpected results.
Hi I just tested and found out that if I am keeping the Status field blank, then the SUMIFS() function is not processing that row. I have pasted below -- the Summary cell formula, and the results coming in both the scenarios: Sheet summary formula =SUMIFS(Amount:Amount, [Due date]:[Due date], <=(TODAY() + 7),…
-
If/Then help
Hi All, I need help with an if/then formula. I am looking to put: if status = definite, then it will populate revenue from the total estimated revenue cell if status = actualized, then it will populate revenue from the actualized revenue cell if status = prospect, then it will populate revenue from the total estimated…
-
Leave blank if row level < 2
I have a column formula with several nested IF statements. I want to add a condition at the start which says "If row is level 0 or 1, leave this blank; otherwise, run the rest of the formula." So I think I need something like this: =IF(LEVEL(Code@row < 2, "", [insert the rest of the formula here, starting with IF])) But it…
-
VLOOKUP
I am trying to use VLOOKUP to determine the column to pull a value from. My columns are basically months (1 through 12) and I need to use the 'current month' to determine the number 1-12 to get the value "@row". I am unsure if VLOOKUP can provide the functionality I am looking for so please let me know if I am asking for…
-
Cross Referencing and sum formula
Hi all, I am working on this new sheet, and have successful formulas from previous sheets that work great. However, I have hit a roadblock here on this one. This formula looks at the Errors sheet I have, and a column that produces a 1 if there is data in the column next to it. With that, I have a consolidation sheet that…
-
How can I create an INDEX and MATCH with 4 conditions?
I am creating a Tracking Sheet where the vendors are assigned to specific team members. In the Tracking Sheet (Sheet #1), there are 2 columns to look at: Coverage Method and Service Provider. If the Coverage Method meets any of 4 criteria, then it should look at the Vendor Sheet (Sheet #2) and return the correct team…
