I'm working on a set of formulas that will find the tasks and list them for the exact matches of the below Department names (among many others). I' have a formula that will work for a few of them but …
I have a formula question that I’m hoping you can help me with. I have a multi-select drop-down in the Stakeholder Department(s) column, which contains several department names. I’m trying to create a…
The formula below works as is to find the 4 specified values. Now I need help rewriting it so that it only counts rows where the "Priority Type/Level" column contains the value "1_Tier 1: Priority Pro…
Hi All, I'm trying to create formula that can (within 1 multi-select column) count a specific value or any combination of a set of values. (We can use the list below for the sake of discussion, and I …
Hi All, I'm trying to write a formula that will return a blank value (or empty cell) that I can add a "write-in" value - which will be different each time the blank occurs. Is there a way to do this, …
Hi All, I'm needing help with some adjustments to the formulas below: In the Total Count formula, I'm trying to count only the number of times each country code occurs, but the 2nd criteria is that th…
Hi All, I'm trying to write a formula to achieve the following: count a value at row/label, but only if it has a date in the "Date Requested" column that fell within the last 30 days: this is the form…
Hi All, I'm trying to write a formula to achieve the following: In the source sheet: Check if the "Resource Type" column contains "Analytic/Data". If it does, it counts the occurrences where the "Dead…
I have this formula that works as it is: =COUNTIFS([Priority Type/Level]:[Priority Type/Level], "1_Tier 1: Priority Project", [Stakeholder Department(s)]:[Stakeholder Department(s)], FIND("Legal", @ce…