-
Past Due Calculation
Hello - I'm trying to build a formula to calculate if a row item is past due based on a value in a due date field. The columns with data are: Approved/Declined Date and Past Due Date. I'm looking for the formula to calculate if Approved/Declined Date is blank and after the Past Due Date to come back with a value of True.…
-
Correcting WeekOf and Avg Formulas
Hi all! I am trying to do 2 operations on some columns I have in a sheet. I have written (with your help ofc!) 2 formulas to fit my needs, these are a week of, and a avg formula. To be more specific, I have a sheet that has tasks on it. Assigned to these tasks are days it took to complete them, as well as the day of…
-
Counting values in a range
I have a column of numbers and I would like to count when the numbers fall between a range of numbers. For example, I would like to count numbers between 5 and 10. So, what would the formula be? This is what I have tried: =COUNTIFS({P&P report - AH - 15 Jun 22 Range 2}, "<5" ">=10")) Please help :)
-
Return Previous status
@Genevieve P. or @Paul Newcome maybe you can help me with something. I have a sheet that i need to include some previous status column that i have in other sheet (probability Change log). I need that the status is the last row updated. In the sheet that i have the previous status i have the status and the "modified date"…
-
Trouble with IF AND formula - i need some help :o(
Hi everyone, need some help, I need a formula to display 5 different outputs based on the conditions set out below, I have tried this based on a IF(AND formula and not getting much back, I can get 4 and 5 to work using =IF(Cancelled@row = true, "5. Request Cancelled", IF([Upload to IMS]@row = true, "4. Request Complete"))…
-
Formula Help Please! Concatenate columns with delimiter & no delimiter for blanks
Hello - any help on this would be amazing. Example worksheet attached and issue below: I'm trying to concatenate 4 columns of emails to create one column of all emails seperated by a semi-colon. The email columns are not side by side and there is a mix of blanks in the email columns. Everything I tried is leaving the…
-
Index/collect returning #no match when there is a match
I keep getting a #NO MATCH when clearly I can see the match. I have used index/collect nested in several IF functions with success, but I cannot see why I'm getting NO MATCH here/ =INDEX(COLLECT(ActualNAR:ActualNAR, Mth:Mth, 3, SCML:SCML, SCML@row), 0)
-
How can I move columns from a row to individual tasks/ rows in a different sheet?
I am trying to conduct a survey at 100+ locations and use the survey results to generate a "custom" action plan for each site based on the responses. Once the action plan/ task list has been created I will need to track the project status of the task completion. The logic for the action plans is easy to address. I'm having…
-
End Date Formula Work-Around when Dependencies are Enabled
Hello! I am working in a sheet where I need dependencies enabled because we are using the GANTT view to show in a report on a dashboard, however I also need the end date of that sheet to be calculated (it is calculated based on another date in the same row). When dependencies are enabled, I'm not able to put a calculation…
-
Using countifs for multiple criteria
I have used the following which results in 'unparseable'. What's wrong with the formula please? =COUNTIFS({P&P report - AH - 15 Jun 22 Range 1},[Primary Column]@row), COUNTIFS({P&P report - AH - 15 Jun 22 Range 5}, "1"))