-
Multi-select dropdown column to pull single value in another column
Hi Everyone! I need some assistance with a formula to extract a single value from a multi-select drop-down. It's a bit annoying as I'm sure that I can use an IF statement, but I was struggling to develop a column formula to use either HAS or CONTAIN. I'm sure it's just early morning brain, preventing me from getting it…
-
Nested IF Health Status Needs
I'm working on a formula to give me a health symbol based on today's relation to the due date and factoring in whether the task has already been completed (based on the presence or lack of completed date). I've messed with it a few times, but it's giving me an #INCORRECT ARGUMENT SET error. Here is my formula: =IF(AND([Due…
-
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…