-
% complete based on count of completed pieces
Hi, I'm running a project where I want to report our the % completion of a sub task based on the # of pieces completed. I'm thinking I need to create a formula as the % of completion functionality looks at duration vs. actual amount of work completed. Can someone offer guidance?
-
Nested IF , logical operator (AND)
Hi All, I am trying to build a formula with IF, AND conditions but i am unsuccessful, can any one help me to sort out this please. Here is the forumula =IF(AND([Position at Practice]227 = "Receptionist", [Current MECA Step]227 = "Step 1"), "19.63", IF ([Position at Practice]227 = “Receptionist”, [Current MECA Step]227 =…
-
% Complete range in If statement how best to describe
I'm trying to have a conditional format occur in a status column, when the % Complete column hits a certain condition, for example: 1. If % Complete = 100%, place "Complete" in the Status Column, and conditional format will change to blue 2. If % Complete is less than 99% and greater than 1%, then place "In Progress" in…
-
Dynamic Future Date based on Condition
Hello, Issue: I need to create a date column that will produce a forecasted date, based on a manually entered date plus X amount of days, based on a certain value (phase). Example: If Phase is "SOW Draft/Negotiations", add 60 days to the "Phase Modified Date" (60 days that will dynamically update everyday, so today will be…
-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?
-
Formula help or advice if possible
Hi, i am hoping some can help or confirm if this is possible. The background: We are capturing data from employees working at 400+ locations. this is being done by a form. the data captured on the form is then being pushed out to individual sheets using a cross sheet formual: =INDEX({Employee Communications for Tupe Range…
-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
How to use "Countif" with reference to CHILDREN in another sheet
Hello - I need some help with the children formula. I am trying to reference another sheet and only pull info from the children of specific hierarchies. The only way that I can do it, as of now and with my current skill set, is if I select all of the actual children. I realize this will be out of formula as soon as more…
-
Formula Between Date
Can someone tell me what I am doing wrong in this formula? =COUNTIFS({HITRUST CAP Milestone Plan v2 - EIS & Sec Range 3}"remediated") AND({HITRUST CAP Milestone Plan v2 - EIS & Sec Range 4}<=(2018,6,30),>=(2018,4,1)) I am trying to count if Range 3 (Status) is remediated and Range 4 (date completed ) is between 2 dates.…
-
Having Trouble with SUMIFS
I'm trying to create a condition based upon user submitted data for over budget flight requests. If the flight type is a One-Way, then whatever the pre-tax amount should be subtracted by the budget amount to give me the over budget amount. This formula is =SUMIFS([Flight Cost (Pre-Tax)]1 - 350, [Flight Type]1, "One-Way")…
