-
Inactivate a task
Is there a way to make a task or group of tasks inactive in a project plan? In Microsoft Project there's a function called Inactivate that's used after you select tasks that you want to make inactive. Doing this does not affect resource availability, the project schedule, or how other tasks are scheduled. I know this…
-
Formula Help - Cross Reference Sheet
Hello, I need help solving this issue that is stumping me. To goal of the cross sheet reference formula is to highlight which employees are no longer with the company. There is logic in place that when the name contains "TERM-", a column will be checked to help indicate to exclude from reports and counts. However, as shown…
-
Adding Minutes to a Time value
I am creating an event sheet, with time information as follows: Setup Time Needed - values will be in 30 minute increments (30 minutes, 1 hour, 1.5 hours, 2 hours) Requested Start Time - values will be in 30 minute increments starting at 8:00 AM to 9:00 PM Requested End Time - values will be in 30 minute increments…
-
#NO MATCH on MIN/COLLECT function
Hi, I am setting up two very similar sheets, with the same columns and similar data (each sheet is for a different date range). In both sheets, I have a column that uses a MIN/COLLECT function to detect duplicates when new rows are moved into the sheet. The formula works in one sheet, but in the other, it returns a #NO…
-
Average of 1 column based on 2 other columns
I am looking to find the average of my KPI Calculations column based on the Go-Live Quarter and the Team. I can get it to work for 1 column but not 2 =AVERAGEIF([Go-Live Quarter]:[Go-Live Quarter], "Q1 2025", [KPI Calc]:[KPI Calc])
-
Using the difference between dates in an IF statement
I have a column the calculates the number of days between 2 dates, which is fine. =[Arch Prelims]@row - [FP Arch Engagement ]@row (gives me a number) But I don't want to do the calculation if the difference is a negative number. There are few instances where the result would be a negative number (very few) I don't want to…
-
Formula Query - Nested IF Statement
Hi, i have a problem where i am tendering on projects, where i request quotes, input the prices, then i will adpot the price i wish to use that makes up the total. Im struggling to get the formula right. Basically it should be the Quantity x Rate, unless it has children and the "star icon" is checked, in which case it will…
-
Sum if week is the same - or blank if none
Good afternoon, I'm sorry for a somewhat redundant question but I've not been able to get this to work. I need to sum up the hours if the days are in the same week. But, if no date, leave it blank. I have a date column that could be used and a week of the month column. This is one of many formulas I've tried.…
-
Date Range in Date Column + Automation
Hello! I have an automation that currently sends users alerts based on the date in a column called "End Date". A majority of the time, the end date is a single date. However, sometimes the end date can be two or more days (ie- May 7th-8th). While I can write into the date column ="May 7th-8th", that will prevent my…
-
Keyboard shortcut to delete a row
Hi Everyone, I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the development queue? thanks!