-
Column deduction formula
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))) + 40 + Bonus@row I need the value amount in (Deduction) column to be deducted from total formula amount ( in Est/Salary) I tried…
-
Project plan header is not pulling/rolling up from sheet rows
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), but nothing is feeding that top row that feeds my reports. I just manually put in the start and end date - which should…
-
Finding a "." in a cell has me perplexed with an "!"
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 risk: 1.1, 1.1.1, 1.1.2, 15.1, 15.2, etc. It isn't easy grouping them together, and auto-number to do this, so I wanted to have…
-
Finding a "." in a cell has me perplexed with an "!"
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 risk: 1.1, 1.1.1, 1.1.2, 15.1, 15.2, etc. It isn't easy grouping them together, and auto-number to do this, so I wanted to have…
-
Does INDEX(MATCH) work on a WBS column with WBS values generated by a formula?
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 project materials. I would like the procurement template to pull the task name and target date from the project schedule by…
-
COUNTIF Cell Value is Negative
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 exist in that column. (This is for a sheet summary). Currently my formula looks like this: =COUNTIF([Delta: Projected Hours vs.…
-
IF cell CONTAINS one/two/three different values, return corresponding values
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" Currently the formula works for single values with the following formula =IF([Type of Project]@row = "Consolidation", "🝢",…
-
Sumifs or countifs and what is the formula
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 duplicate it is blank Based on the location of 101, I want to see how many transactions occurred on 12/1/2023, and are not a…
-
Depreciation Cost Help
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 year of assets currently being tracked in a sheet. We display the cost price paid on purchase, and the date of purchase, but…
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
