-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
-
Stop counting NETDAYS formula based on date in another column
Here are the column names in my sheet that pertain to my question: [Address By Date] [Days Remaining / Overdue] [Date Resolved] The column formula is in the [Days Remaining / Overdue] column and I want it to stop counting when a date is entered into the [Date Resolved] column. The current column formula in the [Days…
-
Multiply Different Columns w/ IF(Or
I'm using the above formula to multiply "MSRP x Final Launch Qty" to find the Project Launch $. But I'd like to revise the formula to include" If 'Final launch qty' is blank, multiply MSRP x Brief Qty" Any advice on creating this formula?
-
Avoiding (email) notifications if assigned to = modified by
Hi all, I have set up a market research project plan with around 60 tasks. Each task is assigned to specific person(s) (could be multiple). I have a workflow where they 'assigned to' contact receives a (email) notification if the row on which he/she is 'assigned to' is changed. However, I only want them to receive (email)…
-
We are attempting to make a column from 1 sheet auto fill onto a second sheet and add new rows
We are making a database. We made a sheet for this (AllJobs3) and are attempting to have this sheet pull the Primary Column from a master sheet (All41). We only want the primary column as the database doesn't require all fields. We have been messing with INDEX(COLLECT), INDEX(MATCH), & VLOOKUP but we cannot seem to get it…
-
How to add multiple status criteria when counting tasks
I am looking to create two summary sheet fields. Formula 1. Count the number of tasks that are due within the next 14 days Constraints: Status must be "Not Started, In Progress, OR Scheduled Due Date must be within the next 14 days Formula 2. Count the number of tasks that are due within the next 14 days but also return…
-
How to Use IF with Multiple Criteria and then to plug in a date - Cross Sheet Reference
I am trying to write a formula that is referencing another sheet. If a row on 2023 Training Request matches the Location Tracker (where im inputting the formula - the studio code is the identifier) AND the Role dropdown on 2023 Training Request is "General Manager" then show the date in the Location Tracker that is in the…
-
Using dates in sheet summary formulas
Hello, I have a sheet that is pulling data from Microsoft Dynamics CRM using the connector where the date data is not coming across correctly if the column is setup as a date format. I have therefore setup the column in the sheet as a text field. I have a summary formula which uses this column to summarize data by quarter…
-
Column Formulas not appearing on Gantt Chart
Hi everyone, I have a column consisting of "expiration dates" and another set of dates called "extension dates" if an extension has been made. I have put the formula "=IF([Extension Approval Status]@row = "ENABLED", [Extension Date]@row)" in the "expiration date" column, If an extension has been made and has been approved,…
-
Formula for counting rows that are past Planned Finish date
I am trying to create a formula that will count the number of row items in my Planned Finish column that are past the date in the cell. I need a summary item so that I can use it on a dashboard to show how many projects are overdue or should be closed. I have been trying to use a COUNTIF formulas that I saw other people…