-
Help putting data in the correct column automatically
Hello. I'm working with a worksheet where I'm trying to put a Workers management team into the correct column based on the Managers Management Level. I'm able to see the flow of an organization by using an INDEX(MATCH()) formula (=INDEX({Manager}, MATCH(Worker@row, {Worker}), 1), but how do I get the data to show up in the…
-
Auto sequential numbering even after moving rows
Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column: I have looked at solutions…
-
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],…
-
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…
-
Formula Help
I am making a risk matrix and I want to be able to calculate the risk score. How can I get this formula to work? I have 5 columns, with the last column being the risk score. I cant get the formula to work and I think it is because of the other formulas in the helper column. If there is a way to achieve this please let me…
-
Cross Sheet References
Hello, I have a tasks list sheet with a parent row as the top level PO # and the children are the subtasks and various line items under the PO #. I want to create a sheet that grabs the DRI person for each subtask but only once at the top level PO (the person will always be the same for the various line item #s under one…
-
How to get the average number of days within a quarter
here is my formula, but I keep getting an error. I can get the average, but now I want to know the average within Quarter 1 =AVG(COLLECT({DYS to Completion}, {Qtr}, "1"))
-
Determine follow-up date that will trigger Workflow
I want a date to populate a field that will trigger a follow-up workflow. My criteria is: If the certification Complete is GREEN, this date can remain blank, as no follow-up will be sent. If the certification Complete is YELLOW or RED, the Manager has either partially completed (yellow) or not completed at all (red). The…
