-
Speed up loading of a Report linked to multiple Sheets
I have a number of Workspaces representing different Projects. I want to be able to Report on specific Sheets within each Workspace. I have several different Reports, each uses data from a different Sheet within the Workspace(s). Whenever a new project (Workspace) is added, I amend the Report data source to include the new…
-
Index Collect formula?
I am trying to collect information from a combination of 3 sheets. Job Duties is a multi select on employee Database Crew is a multi select on job log Vehicle is multi select on job log Driver on asset summary sheet would pull in Driver(s) from the job log based on the vehicle. On the Asset Summary Sheet, I’m trying to get…
-
Formula to count media in market
Hello, I'm looking for a formula to count media based on their date range. 1) Count media where date range (start & end date columns) are in the PAST 2) Count media where date range (start & end date columns) include TODAY 3) Count media where date range (start & end date columns) are in the FUTURE I believe I have 1 & 3…
-
If, and & if logic unprasable
Can you see what is wrong with this syntax? I am getting an unparsable error. =IF(AND([Status]@row <> "Complete", [End Date]@row >Today()), "Red", IF(AND(Status@row <>"Complete", [End Date]@row < Today(-7)),"Yellow", IF(AND(Status@row = "In Progress", [End Date]@row > TODAY()), "Green", IF(AND(Status@row = "In Progress",…
-
Joining Child Rows if meets Criteria
I am attempting to write a formula in which I want to join child rows from a column titled "Assigned Workgroups/ Work Teams" if the child row has "On Hold - Pending Add'l Info" selected from a column titled "Decision Status." The outcome should be a list of workgroups/work teams on the parent row if the decision status is…
-
Collect cell value based on two check boxes in another sheet
I am needing help to collect a value from a cell in a different sheet based on two boxes checked on that sheet. I want to collect the value in [Event Level] based on the following criteria: [Operational Area] = "Airside" / [Max Date] is checked and [Area] is checked Regards, Ron
-
Date without time
Hi - I'm trying to add a column that has text and then pulls a date from another column. Example: Meeting date: [date from other column]. When I do this it says 8:00am and then the date. How do I pull just the date and take the time off? Where is that time coming from?
-
How do I populate the highest parent level data into another cell?
I'm using the '=PARENT([Primary Column]@row)' formula, but it's populating data from the parent row, even if the parent row is a child of another parent. I need to populate in a separate cell data from the highest level parent row. In the example below, is there a formula that would populate Primary Column row 1 data,…
-
How to avoid circular reference?
I am trying to sum purchase orders based on where the items are coming from. =SUMIFS([Bag - 55 Gal Trash]:[Bag - 55 Gal Trash], [Were these provided by the Warehouse or Job?]:[Were these provided by the Warehouse or Job?], "Warehouse") =SUMIFS([Bag - 55 Gal Trash]:[Bag - 55 Gal Trash], [Were these provided by the Warehouse…
-
I am working on a date Formula and I was able to get Feb, but it's not working for the other months?
I am putting together a KPI for my customer. I have to put how many PTD's we have for each month. The month of Feb. is working but I can not get the other months to work and could use some help.