-
Sum Collect Index Match with a calculation...
I have a list of items and costs associated with the item. I would like to build a formula without the use of a helper column to calculate the total Value of items based on the quantity of items. The list of items is about 300 lines and the number of "people" will be a fluctuating quantity... I would rather not create…
-
Is it possible to attribute all levels of child rows to the same parent hierarchy?
I have a Project Plan with multiple levels of hierarchy, but I'd like to have a column formula that would tie everything to its relevant parent. Essentially what I am looking for is a formula for the Project Column below where even the grandchild or great-grandchild tasks associate to the highest level parent w/in the…
-
Backtracking Formula Origination - "Cost#"
Has anyone ever used or seen "Cost#" used in a formula? I'm not sure what it's referencing, but it doesn't look like anything specific to my sheet. Any insight is greatly appreciated!
-
Rich Formatting On "Summary Sheet"
I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from multiple sheets and can be formatted. I have 20-30 real estate development/construction…
-
Formula to automatically link Week to Date
Hello, we have individual production schedule sheets where we assign hours against weeks. We want to create a column that will autofill with the Date it is starting based on the first Week Number column that has hours in it (example attached). We have this working with a long formula: =IF([wk 23]@row <> "", "06/06/22",…
-
Conditional Formatting
Help! :) I cannto get my conditional formatting to work on my sheet - what am i doing wrong. Here is an example of the format i have used We are trying to use data from anothet column to turn a seperate column green or red - is this possible? Or can i use a formula to do this?
-
Vlookup issue : When column are added to
Hi, I have successfully applied a Vlookup from reference sheet to my parent sheet. However, when a new column is added within that range in reference sheet then input value also changes and it doesn't remain static. Is there a way to apply same logic like Excel with $ sign to make the Reference value/Reference column…
-
Help with this IF this then this formula
Please help me figure out what I am doing wrong with this formula: =IF((([Size of Install]@row = "Small - Single Server, no HA, no NLB, HPAC PP+IA+, no HPAC Scan, no HPAC mobile connector, includes PPM/PDM, WJA, UPD, 500 printers or more - remote/travel extra, for small AlertX configuration only, single server for PP,…
-
Multiple Results Formula
Hello! everyone I was wondering if someone could help me with a formula We have an audit schedule based on 5 years and I currently have the "Count" essentially telling me how many times a topic was audited in the past 5 years. What I would like to generate is - "in which years was the exact same topic audited?" which would…
-
Using "If" with dates
Hi all, I'm working on a sheet where I'd like to reference a start date for a task and then, based on the current date, auto-populate another column with a status update (not started, in progress, overdue, etc.). I think I want an "IF" statement-something like "=IF([reference column])>today, "Not Started") but I"m 100%…
