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…
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.
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…
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…
I have a sheet to track data for incidents at different buildings by date. I'm looking to have the building cell be highlighted if it has had multiple incidents in the last 30 days. Ideally if I can do this with conditional formatting or use a check box formula that feeds into it.
I would love to offer a legend for users to understand the conditional formatting for a given sheet. Not all users are able to see the rules and may not remember what the formats indicate. Adding a button or pop-up banner/tool tip would be a great improvement. I try to use the column description when I can, but the…
It would be nice to have the option to select all/some conditional formatting that need to be removed. Some sheets have many and even though they can be disabled, they need to be removed for structural changes.
It would be great to provide an option to remove all workflows on a given sheet instead of having to click through each workflow. Alternatively, when a workflow is deactivated, the admin will be allowed to delete columns even though there is a deactivated workflow in place. The pop up should stay but an admin or owner…
Hello! I am currently attempting to write an all encompassing formula to read through different work windows. We are only able to work in certain areas of the city depending on the "work window". Depending on the work window, these dates have differing start and end dates. I can get one window to work properly, but the…
Hi all, I have a sheet with columns that list a particular service. My rows are site names and we're tracking the level of adoption for each service with the below list: FI (H) FI (NR-H) FI (NI) C-FI P NI V N/A I want to have each one colour coded like you would with conditional formatting but I have 28 columns and so if I…
