I am trying to create a cross reference formula that will link information from one sheet to another. The first sheet (Roster) that has a bunch of position data, including the position number. The sec…
Hello everyone Im trying to add Deduction col to my formula in screenshot/below: =(IF([📈 Monthly Target]@row <= 600, [📈 Monthly Target]@row * 0.15, 90 + (([📈 Monthly Target]@row - 600) * 0.25))) + …
I just realised the top row is not rolling up percentages, dates or durations. Dependencies are enabled, and the entire rest of the sheet is functioning fine (so I don't want to disable dependencies),…
Okay, bad pun, sorry. It's been a rough search today. I have an ID field for tracking Risks across projects. Each risk has a whole number: 1, 2, 15, 22, etc. Each mitigation is a sub-number of the ris…
Okay, bad pun, sorry. It's been a rough search today. I have an ID field for tracking Risks across projects. Each risk has a whole number: 1, 2, 15, 22, etc. Each mitigation is a sub-number of the ris…
Hello, I have created a project schedule template for my team, with tasks, subtasks and associated timelines on one sheet. I have a second sheet where I am creating a procurement template to track our…
Hello! I don't yet see this question put out there, so here we go: I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exi…
Hello community, I am attempting to return single or multiple values depending on a multiple dropdown column. My dropdown column contains criteria "Consolidation", "Reduction", "Termination", "New" Cu…
I have 3 columns of data: Column 1 is a location (for example 101, 102, 201, 202) Column 2 is a date (for example 12/1/2023, 12/2/2023) Column 3 is a duplicate transaction labeled as D or if not a dup…
Wanted to use the template listed to create a new sheet and see if it would work that way, but it isn't available any longer.. Essentially, I'd like to be able to find the depreciation cost year over …
