-
Why is Dynamic View allowing me to build logic based off one set of dropdown values but not another?
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
-
One Conditional Formatting Rule Not Taking Priority
I apply a similar strategy of conditional formatting to a lot of sheets and don't usually have any issues, but on this one sheet, I have a rule that's listed above the others, but it's not taking precedent over the other formatting rules and I'm not understanding why. I have a cascade of blue colors to denote "header"…
-
Conditional Formatting Gantt Bars & Other Columns
Currently, if conditional formatting is applied to Gantt bars, the format must be applied to the "entire row". I would like the ability to apply conditional formatting to the Gantt bars and additional formatting to individual columns. Example: format Gantt bars red, yellow, and green for large, medium, and small impact…
-
How do I set conditional formatting, based on dates, to span across columns representing quarters?
Hello! I am trying to create conditional formatting based on a range of project dates that will fill cells representing quarters. For example: if the project spans 5/6/24 - 9/1/24, I want it to shade the Q2 24 and Q3 24 cells. If the project spans 5/6/24 - 1/5/26, I want it to shade cells Q2 24 through Q1 26. See the dark…
-
CountIF for a multi-select drop-down
Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because it makes the most sense for me. In the sheet summary tab, I want to be able to count how many rows need…
-
Conditional Formatting Not Working as expected
I'm trying to apply conditional formatting to a sheet and it looks like it's ignoring the conditions that I've outlined. First, when you apply more than one condition to a sheet it's an AND and not an OR, correct? Second, these are the conditions I have set. When I have both conditions enabled AND the date is in the next…
-
How to edit filter to include YEAR function
So I had this formula created and its searching by a couple of different metrics to gather the average of a column but only via the supervisor name for another column. Silly me forget we only need to spit back data from 2024 as the sheet collects multiple years worth of data and my brain is really struggling to add this…
-
Conditional Format entire card in card view
I am ok with the task bar conditional formatting BUT would like to have ability to color the entire card and not just the left task bar.
-
Counting individuals supported by specific customer removing repeats
Hi, I am trying to sum the number of individuals that are supported by a customer. There are several opportunities that support a single customer and within these opportunities the same individuals may be supporting the customer. How do I calculate the unique number of individuals who support a single customer. The…
-
Formula Insertion via Conditional Formatting
Hi, I've made several formulas for one of my sheets to identify task health based on several conditions, which all work fine. However, my problem is when I insert a new row I need to identify the health formula for that row based on the task indent level (parent/child/grandchild) which I don't know how to do. Has this been…
