Leeweber
Leeweber
Discussions
- I have a project management sheet. CSYYXXXX is the header for the project name column Tasks is the tasks column - at the parent row, I just write "Tasks" and then there are child rows below that. Some…
- In this sheet, I have a column [Groups] which is a parent column to multiple "Groups", each of which is a parent column itself to tasks associated with each group. I need help putting a formula in [St…
- I'm looking to create a unique ID per entry as YY-### that will reset each year (24-001, 24-002, 24-003, 25-001, 25-002 etc) Row ID: (auto number column) YYYY: =YEAR([Date Submitted]@row) YY: =RIGHT(Y…
- Can someone help me with an Index/Match or Index/Collect formula to accomplish the following logic? When {ArchiveCSYYXXXX} = CSYYXXXX@row AND {Task} = "Final Signed", provide {FinalSignedDate} In case…
- I'm making a training matrix for my company. Source sheet is the "matrix" that will list all employees and their required trainings: *RowID is auto-numbered column *RowNo formula is =MATCH(RowID@row, …
- Hi - trying to make a Training Matrix for my company. "Matrix" sheet has the following columns: Row: (Auto-Number) Doc ID: (Text = document needing to be trained on) Employee 1: Check Box if they need…
