Trending in Formulas and Functions
-
Using countif to select an option from a column
I have multiple selections in a column and when I tried to use countifs, it will not pick up the label that is combinated with other options. For example, in Column B, I have following look up values - Role 1, Role 2, Role 3, etc, but some rows have two or more roles - so in one row, it will say role 1, role 3. In another…
-
How can I fill in a field with a name if my Location column is a specific city?
I am attempting to autofill data into a field (person's name/contact) if the city is the one they administer. I am receiving an incorrect arguement statement error. Here is what I have so far. =IF(CONTAINS("Milwaukee", Location@row, "Michelle"), IF(CONTAINS("Appleton", Location@row, "Stephanie"), IF(CONTAINS("Madison",…
-
How do I add an additional piece of criteria to this formula
This is the current formula =COUNTIF({CAR Range 1}, AND(@cell >= DATE(2022, 1, 1), @cell <= DATE(2022, 1, 31))) I want it only to count the cells with this date range AND that have the word Toyota. How would I modify the current formula?