-
How to count number of vendors in each country?
Hey Community, I am simply trying to calculate the quantity of contracts assigned to each vendor per country (Ex: I want to see that IBM is covering 100 contracts for us in the United Kingdom). The columns I have to use for this are the following: Vendor assigned, Covered Country (on the same sheet) Countries, Vendors (on…
-
Achieving Optimal Index-Match Performance
I'm wondering if anyone has any insight as to whether or not Index-match works any faster when the fields being used in the look-up contain numbers only, instead of text or text/number mix? In my own anecdotal experience, sheets that use index-match on numbers-only columns do seem to open/update/save faster. But I have no…
-
RYGB Lights Not Changing with Dates
I am not sure why my lights wont change based on the dates: =IF([Original Due Date]@row < TODAY(14), "Yellow", IF([Original Due Date]@row < TODAY(7), "Blue", IF([Revised Due Date]@row > [Original Due Date]@row, "Red"))) Would like: Yellow: <14 days from today Blue: <7 days from today Red: Revised Date < Original Date
-
Formula Assistance (COUNTM??)
Hello all, My team and I are hoping to build a formula to do the following: First, identify all items that belong to "Group A," then count how many items the rows that belong to group A have in "Color." So, for example, the answer for this would be 4 (because there are 4 items in the "Color" column that belong to Group A).…
-
Countif with column and cell reference instead using "XXX" name
Hi, i am building a large list of client that i going to use to create Dashboard with counting items per each client. My question is (maybe it is very basic), is there a way that in the formula Countif i can refer to the cell and column instead or using the "XXXX" name in the formula? here the formula that i am using and…
-
Charting with dates using the data on the Report Item
The labels for my date are weird. How do I fix? The information under each Due dates are file names.
-
I need to calculate past due items with 2 column dates
Hi I need to create a formula that help me to calculate the past due items but using to columns with dates. One is the the first column with the "Expected closure date". This will be the primary column to check or validate. But we have another one called "Amended closure date", that will have another date that probably…
-
Symbols for Status
Why are my words not translating through to symbols? The formula seems to work since its returning the text, but ist converting it to symbol form =IF(Status@row = "Assigned / Not Started", "Empty", IF(Status@row = "In-Progress, On-Schedule", "Green", IF(Status@row = "Delayed", "Yellow", IF(Status@row = "Complete", "Blue",…
-
Formula help to match contains
Hello! I have 2 sheets: Sheet 1 contains [UserId] column Sheet 2 contains [Assosiated User] and [Machine Name] columns I need to Use [UserId] to look up if [Associated User] contains text to match [UserId] and return the value of [Machine Name] at row Just cannot seem to figure it out. Any help is appreciated!
-
COUNITFS w/Ranges from Multiple Sheets?
Hi all, I'm trying to create a COUNTIFS formula that will look for the same criteria within multiple sheets (5+ sheets at a time). I have my criteria in one sheet, and want to look across other sheets for instances of that specific criteria, then tally up the instances in the original sheet w/the criteria. I'm setting a…