-
Date Calculation Formula
Hi I'm after some ideas on the best way to calculate a [Date of Next Review] based on either a [Start Date] or [Last Review Date]. If the Start Date is in the last 12 months of today and [No. of File Reviews] = 0, I need the [Date of Next Review] to be [Start Date] + 3 months If the Start Date is in the last 12 months of…
-
Counting tasks across multiple sheets
Hi there. I have 17 separate project sheets. I have a portfolio-level dashboard and I want to include a metric that sums the total number of tasks across all of the sheets. I've been searching all over for the best way to do this. Some people have said countifs others have done roll up sheets and cell linking, etc. I do…
-
combining 2 criterions
Hello I need help with combining 2 criterions in one formula, =SUMIF([Project Status]:[Project Status], "Complete", LM:LM) I need to know the total LM (lane miles) for projects that are completed and located within a specific district CD Total # projects Total LM completed within District A 8 B 7 C 9
-
Removing AM/PM
Is there a quick easy way to remove AM/PM from column entries. Making 9:00 AM, 9:00 Thanks,
-
How do I update multiple cells when one cell is updated?
How do I update multiple cells when one cell is updated? Example A: If Done is checked, then Status is updated to Completed and Progress is updated to Full. Example B: If Status is updated to Completed, then Done is checked and Progress is updated to Full.
-
Help creating a formula
Can someone help me fix the following formula? # of Travel Trips = IF(([Onsite Delivery]@row = "Onsite" , [Software Installation Hours]@row >40, 1, or <41-79, 2, or <80, 3) * [Number of Sites]@row)) Not sure what to do with the ORs...or how to include them all into the formula. Do I have too many parenthesis?
-
Sum of Max Value across multiple rows
Hello, I need some help working out a formula that will let me sum the max value across 2 conditions... I have a data sheet that is getting rows copied to is when values are changed on multiple project sheets and i need to have a formula on my report sheet that returns the sum of the highest value in a day for each…
-
Is there a formula for referencing a different cell daily?
I've automated emails to send out schedules to our field employees but their sites can change daily and I was wondering if there's a way to reference a different cell everyday so I don't have to manually change the site cell in the automated workflow.
-
Formula help: Check box if field in another sheet is a date
I am attempting to use an IF statement with an Index(Match( to check a box in my target sheet if a matching field in my reference sheet is a date. I am attempting to match the Vendor Names between the two sheets and have used the below formula but am getting a #NOMATCH error. =IF(ISDATE(INDEX({Contract Management - Sub…
-
Counting number of tasks per Assigned To contact
My task list contains parent, sub-parent, then children tasks. The workstream leader is assigned to both the parent and sub-parent tasks, and possibly sub-tasks as well. I need to count the number of tasks per "Assigned To" contact. It would be ideal if parent tasks are not included in that number, but it's manageable if…