-
Automate Flagging at risk task based on approaching due date
Hi Community, I am looking to automate flagging a task if it comes within two weeks of one of its two due dates (each task has a recommendation date and approval date) and its currently not complete (of which there are two opportunities for it to be complete, the recommendation and the approval). The task must have a…
-
Status Roll Up to Parent
Hi, I have a column that has the following status distinctions: Remove Not Started In-Process Final Draft Ready for Group Review Group Review Complete Final TechPubs Complete PTP-In Process PTP-Approved I am looking for a formula that would be set for the parent but only show: Not Started In Process Complete How should…
-
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,…