-
Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
-
VLOOKUP for Multiple Sheets
Hi - I am trying to use VLOOKUP across multiple sheets. I have one column that is labeled clinic #, and I want to search for this clinic number across 2 different sheets, and we want to display a specific cell from that line it pulls. I have no problem doing a VLOOKUP for one of the sheets, I am running into an issue when…
-
Formula Help to Set up Sprints
I am using this formula to set the sprints in my project plan but get the error "your formula syntax isn't quite right". Looking for help in what I am missing. Thanks = IF(AND( [End Date]@row > DATE(2024, 11, 27), [End Date]@row < DATE(2024, 12, 10)), "Sprint1", IF(AND([End Date]@row >DATE(2024, 12, 11), [End…
-
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…
-
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
-
Formula for 24hour clock overlap - booking clashes at the same time on the same day
Hello all, I am hoping someone out there has a smart idea of how to pick up on reservations overlapping within a 24hour time period. In this instance, there are two people parking in same bay on the same day. Formula I have is: =COUNTIFS([Date Of Parking]:[Date Of Parking], [Date Of Parking]@row, [Bay Number]:[Bay Number],…
-
How can I automatically populate a cell with the same info from another cell (SAME COLUMN /DIFF ROW)
Hello, I have 1 sheet that I am creating and will continually add new rows of data to over time. There may be cases where an account number is listed more than once on multiple rows. If the account value was captured previously I want the account value number to autopopulate in the new row for that same account number. Ex:…
-
Group Rows - Parents & Children
Hi everyone, I’m hoping to get some help from the community. Is there a way to automatically group rows in a parent-child format? For example: Parent A Child A Child A Parent B Child B Child B Parent C Child C Child C Each time I add a new row, I’d like it to automatically group based on this logic. If I add a row name…
-
Help with COUNTIFS, two criteria from the same column
I am being dim I am sure, I need to count some information that has been imported from an excel spreadsheet which is a download from our membership database so the formating is odd. This will be a regular download and upload so I don't want to spend time tidying things up so hive mind. This below works fine but I also need…
-
Need a column to have sequential numbering even when rows are moved around
Hello! I have a column that needs to have a list of numbers that stay consistent even when rows are moved around. So if row 3 was drug up one the primary column values are x, z, y, but column 2 would still be 1, 2, 3. Thanks in advance!
