-
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…
-
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??
-
If project status complete - stop calculating formulas & Conditional Formatting
Greetings, Currently at row 1600, waiting for a cell's formula to process the formula may take up to 10 minutes. For instance, sometimes when I change the duration of a Child row by 1 day, it may take 10 minutes for the End Date to advance by 1 day. I use A LOT of formulas, cross-sheet references, as well as Conditional…
-
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…
-
Nested If Formulas with conditions in 2 columns
I'm trying to figure out how to create a formula that has a red flag appear if the following are true. I can't seem to figure out how to put the whole formula together. Any help is appreciated. Thanks! IF(AND[Due Date]@row < TODAY(), Status@row <> "Complete" 1, 0) IF(AND([Due Date]@row < TODAY(), Status@row <> “Closed”),…
-
Separate Data
Does anyone know how do you split data in one cell into multiple columns?
-
Countif Formula
Hi everyone! Im having trouble with a simple COUNTIF formula. I am getting "UNPARSEABLE" but for the life of me, I just don't know what I'm doing wrong. I want to count how many times the "Weekly Goal" was met in a range of cells. screen shot attached.
-
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:…
-
IF function 100% Complete
Hello, I'm trying to figure out using a symbol column type, once the visual symbol of a checkmark is selected, to then have the % complete column populate "100%". I can't seem to figure out the correct function to apply to all cells under the symbol column to automate this action. Any help on accomplishing this is greatly…
-
Count Checked boxes from another sheet
Hi - I've seen this question a few times, but I am still not able to get this to work. I have a Metrics page that I am rolling totals up to so I can display a donut chart of projects per GEO. This has worked, up until now, because I have a single column as a drop-down to show these metrics. =COUNTIF({Geos}, Metric9)...I…
