-
index match using multiple critieria
Hello, I want to use a formula using INDEX/ MATCH Function using multiple criteria to get a single value I am trying to get a value of Column Description from File 2 based on matching Source System ,Table name and Attribute Field Index ( as the column names may be different ) The formula Im using gets me an INVALID…
-
Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
-
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
-
Count how many times a multi-select value was selected in a cell range or column
Hi, I am trying to count how many projects from another sheet has a specific OKR value selected in a multi-select dropdown column. Example: There are 4 projects, all of which could be assigned to a single or multiple OKR values. I need a formula to count the number of times, e.g. 'Improve Operations Efficiency', was…
-
Form with multi drop down answers - need help to count correct choices
Hi All, I have built a post training test form for a colleague, some of the questions have got multi answer choices (e.g. correct answers can be A, B, C, D or even choice of E - stating that all previous choices are correct; or could be that A,C,D are correct). If correct choice is chosen, needs to return point 1 per each…
-
Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
-
How to pull one of the headers from the primary column which is under a hierarchy
I am trying to pull the header which has an ancestor 1 assigned to it i have a forumal below which i am tryign to tweak but i cant get it to work to get the dark blue header can anyone help me please @Paul Newcome if you are free Paul, i would appreciate your help on this please?
-
Original sheet is corrupted or has some hidden issue preventing the formula from working?
I have a sheet where a formula in one column is not being applied . However, when I save the sheet as new, the formula works as expected. Is it possible that the original sheet is corrupted or has some hidden issue preventing the formula from working?
-
Nested IF Statements
Hello. I cannot figure this out. =IF([GL Code]@row = 14030, "Leasehold") How do I add additional IF statements in the same cell, for example if the GL Code@row = 14040, "FF&E", GL Code@row = 14050, "CR Equip" Thanks.
-
Displaying %Complete Column on Metrics Sheet
Hello! My coworker and I think we are close to figuring out this formula on our Metrics Sheet but we keep receiving the "Incorrect Argument Set" message. Here's the formula in the screenshot: =INDEX(COLLECT({Per Complete}, {P2H Task}, $Reference@row , {Milestone}, 1)) {Per Complete} = the %Complete column in the source…