Trending in Formulas and Functions
-
Looking to Countif a person's name is contained in a column that allows for multiple contacts.
=COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row)) the OTP Goals Project Lead is the sheet that has the column that is a contact list that allows for multiple contacts. If a person's name is contained in that column and it matches the name in the column on the metrics sheet called Contact - then I want it to count…
-
Replace Multiple Values with Multiple Values
I have a Status column which is a dropdown list. I would like a formula that checks the Status column and returns a different number for each item in the list. Any suggestions on how to do this? STATUS. RETURNED VALUE "NA". "1" "Not Started". "2" "Priors Pending" "3" and so forth.....
-
Return Ancestor Data by Level Designation
I'm logging multiple years' worth of data into a single sheet that is organized by year, quarter and month at Levels 1, 2 and 3. I believe I need to use the ancestors function along with index (maybe?) but I can't seem to find a formula that works. A snapshot of my table is below. In words, I want my Year column to return…