-
Vlookup formula issue
Hi there- I had a formula entered into my worksheet that would auto-assign a colleague to order requests based on what groups they did ordering for. Somehow the formula was augmented so that it no longer worked. (i.e., I don't know what happened! I'm still learning.) I have the corresponding columns in the primary…
-
How can I identify multi-select cell values that are not in the dropdown list?
I have a multi select column "Cost Code." There are currently values in the column that are not within the dropdown list. For the "Accessory Code" I was able to check and flag these via the following formula where I reference a column in a separate =IF(CONTAINS([Accessory Type]@row, {A&A Column Selections Range 1}), 0, 1)…
-
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…
