-
converting to a column formula
I am attempting to =IFERROR(SMALL([Lowest Quote]6:[Lowest Quote]9, 1), "") into a column formula I am unsure of the changes needed to make it work. I want to have the lowest quote in the children tasks to populate on the parent task bar.
-
Can I use an IF formula to return a value where the reference column is a multi option drop down??
I am trying to create an IF or CONTAINS formula that references a multi option dropdown cell to returns an email address for every department selected in the cell. i.e. 'Other Departments Impacted' CONTAINS "Sales" "Accounts" "Delivery" so the 'Associated Contacts' cell returns "John Citizen", "Fred Smith", "Tony Dory". Is…
-
Nesting IF Formula
I am attempting to create a tracker and the current formula is creating the dreaded "#UNPARSEABLE". I essentially am trying to autopopulate a number into column two, based on the name entered into column one. When I utilize the formula =IF([Employee Name]1 = "John Doe", {Employee ID Numbers Range 1}) it works fine. But…
-
Simple COUNTIFS formula w/ # INCORRECT ARGUMENT SET
Hi, I am having trouble with a COUNTIF formula. I am using the below formula that keeps giving me the INCORRECT ARGUMENT SET error message. I used the same formula to count the blank cells on another sheet and that worked, but this is not counting the not blank cells. =COUNTIFS({Final Sent}, {Patient Status}, "Closed",…
-
How to account for blank cells in a complex formula
Current formula: =IF(COUNT(CHILDREN()) > 0, IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") > 0, "Green", IF(COUNTIFS(CHILDREN(), "Blue") > 0, "Blue"))))) What is the formula for the highlighted bullet? Thank you so much!
-
COLLECT() isn't accepting column for range
I am trying to do the following formula using an entire column in the range: INDEX(COLLECT(ColA:ColA, ColB:ColB, ColC@row, .... But, this doesn't work. Instead, I am forced to enter row numbers in the range as follows: INDEX(COLLECT(ColA1:ColA52, ColB1:ColB52, ColC@row, .... However, using row numbers in the formula now…
-
How to add an IF statement to a formula that returns the number of months between two dates
Hello Community, I'm trying to write a formula that returns the number of months remaining in a term if a date is provided, and if no date return "NA". I have =ROUND((NETDAYS(TODAY(), [Lease Expiration]@row) / 365) * 12), but not sure how to make this formula return "NA" on blanks instead of an error:
-
Greater than/Less than dates AND confusion
I need to calculate a number based on if a date is greater than or less than dates AND based on a selection in another column. example: If current date is between january-july from current year AND discipline dropdown is HHA then return number 6 in hours required and if the dropdown is PCA return 3. Discipline column has…
-
Autofill Function
I have a reference sheet where there are "Show Codes" for each game from a Drop Down. I have been trying to use the VLookUp formula but keep getting a #No Match in the column I'm attempting to have the autofill occur. Images below - Basically I want the corresponding show code to autofill when a specific game is selected…
-
Iferror(vlookup) not pulling all data from a cell.
I am using the Iferror(vlookup) function to track my teams inspections. Recently, I changed the form to have multiple locations, and since then the iferror(vlookup) is not pulling every locations date from the data set. Picture 1 is an example that pulls the data properly, picture 2 does not pull the data, and picture 3…
