-
Countif children row with reference another sheet
I want to count the children rows in another sheet that contain a certain value, my attempt gets an #UNPARSEABLE =COUNTIF(CHILDREN(){Lease Tracker 2018 Manager},="CORNELIUS")) Any thoughts? THANKS!
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
VLOOKUP - I think?
I am doing estimates for projects. Each job title has its own rate and there are different rates based on specific clients. What would my formula be if I want to reference a particular cell based on these two parameters. They would live on a master rate sheet that could be referenced.
-
How to Create Tend Arrows with a Function
I have a cross sheet table with data displayed on it that works fine. Just wondering how I can display a trend arrow using a function for Up, Down and Across. Basically, I am measuring KPI performance against the number of days since the last time we had for example a Lost Time Injury or as is known as an LTI. This work…
-
Formula help predecessor
I need a formula for If there is a predecessor the status of predecessor is complete (other row) than show "start" If there is NO predecessor show "start" How can I make this? Name of columns: Predecessor: Voorafgaande taak Status: Voltooid THANKS!
-
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”),…
