-
IF function with many conditions
I have an internal client who wants to parse a list of 100 different zip codes, and depending on the zip, assign another text field into a different field. In other words, IF zip code = 11733 OR 11725 OR 11890 (and so on) THEN assign to New York. Maybe there is a way other than using IF? Thanks for any help you can…
-
Vlookup
Hello, We have here 5 different sheets containing records for Medical service details, including columns for patient name, ID, DOB, charge amount, payment status, etc. Now i want to get a sixth sheet that will look up from the above 5 sheets only the rows that's stated as Denied, so i can view all denied claims in one…
-
COUNTIF formula
I am trying to count the number of projects completed between July 1, 2018 and June 30, 2019 with this formula: =COUNTIFS({Status}, ="Completed", {Completion Date}, >=DATE(2018, 7, 1) <= DATE(2019, 6, 30)) The outcome is supposed to be 6, but it is reading back 7 (it is also counting San Antonio). Does anyone know why??
-
Trying to count multiple people in a cell
I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard. I am using the formula: =COUNTIF({Project List Range 3}, Assigned1) Where Project List Range 3 is the Column in my master sheet…
-
IF / OR Formula help (#Invalid Column Value)
Hi everyone, I am trying to figure out a formula, that will show the following result: * If the completion date is before the due date, the green circle appears; or * If the completion date is after the due date, the yellow circle appears; or * If the completion date is blank, the red circle appears. The formula I have is…
-
COUNTIF with Parent rows only, exclude children
I want to create a COUNTIF function that will count only the Parent row of a status column in a project tracking sheet. This is to create a metric sheet that will show all project statuses by each project manager's sheet. There is a status column using Green/Yellow/Red/Blue identifiers, and children rows need to include…
-
Count values in a column or Pivot table
Hello, I don't have a pivot table app so I am looking for formula help. I have a grid that has a column called "Goal". Users and choose a value from the drop down or type in their own value in this field. I need to be able to generate a pie chart that shows the number of times each value shows up in that field. For…
-
Separate Data
Does anyone know how do you split data in one cell into multiple columns?
-
Hierarchy tagging
Greetings, I have a organizational structure that has three levels * Campaign * Project * Deliverable * Task I am trying to figure out a way how I can have a column with one of the above values that is based on hierarchy. I have the project and deliverable part figured out using the following formula:…
-
Overall Average Percent Compete
Hi All, I have looked around on multiple forms and haven't been able to find a solution for why my formula isn't working.I am trying to determine the formula for the total project % complete of the children rows. For the Project Initiation rows I have the formula =ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0,…