-
What's wrong with this formula?
=COUNTIFS({Sheet - Sales Pipeline Range 1}, Client@row, {OD&I Pipeline tracker Range , "Pipeline")) It just reads UNPARSEBLE. Thanks Phil
-
Calculate Week number from multiple choice dates column
Hi, We are running a Wellness challenge for a charity. Participants log the days and duration when they performed the activity. We allow selecting multiple dates for the same activity. I try to total Duration for a week. "Duration" mean the number of hours for each of the selected days. First, I need to convert a date into…
-
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?