-
Match Function to Return Required Digits
Hi Smartsheet Community! I am running into a problem and need some help with a Row ID formula using the match function. I have a project plan that is generating a unique Row ID, using a combination of an Auto ID Column Type (Row ID), the Client & Project Code, and a match formula to return the actual position of the row in…
-
SUM MATCH Formula
Looking to find out the correct formula for the below scenarios Sheet One contains: - Price and Contract ID Sheet Two contains: Contract ID Formula should be added into a column on Sheet 2, summing the Price of all rows from Sheet One where the contract IDs match
-
DataTable changing information in unmatched cells?
Hello. I have setup a DataTable to popluate a log I use to track approved invoices by job. I thought it was working fine, but have noticed that the fields I am NOT matching (and which contained formulas, text, or other references) have their contents deleted. I am using the filter option. In addition, the filter criteria…
-
Cross-Referencing Another Sheet for Matching and Looking Up Values
Hi! In my first sheet, I have a column "Date Submitted to Courseware". Then, someone selects an "Analysis Priority". First sheet The Analysis Priority should look up the References sheet to the columns for AnalysisPriorityTypeDropDown, match that, and figure in the AnalysisPriorityTypeValue number of days, and figure in…
-
INDEX / MATCH / CONTAINS Assistance
Looking for your help, the below formula works for the moment: =IFERROR(INDEX({SFDC Opps for Renewals Range 1}, MATCH(SFOP@row , {SFDC Opps for Renewals Range 2}, 0)), "No Match Found") However the column above actually contains multiple SFOPs and so I think I need to add a CONTAIN element to the formula so when SFOP…
-
Cross-reference sheets to find matches
Hi! I am trying to determine how many of our students are later hired by our institution. I have a Sheet with a Student Name column , and would like to add a "Hired" Column in this sheet that would cross reference to a second sheet (Master employee list) and flag if there is a match in the Employee Name column (so if a…
-
Index/Match formula using a range of values?
Hello, I'd like to create a formula or series of formulas to accomplish the following… There are two sheets: Source Sheet Return Sheet Source Sheet: https://us.v-cdn.net/6031209/uploads/RY816MEYP46R/example-source-sheet.xlsx Return Sheet: https://us.v-cdn.net/6031209/uploads/ZG5YB9OMWQK4/example-return-sheet.xlsx What I'd…
-
Listing cell contents from multiple cross reference fields in one cell (if statement, index/match?)
Hi, I am trying to do an if/index/match statement to pull the contents of a cross reference cell if it is not blank into a single cell. I need to be able to list several non-blank values with a paragraph break in between in a single cell and I am drawing a blank. Right now I have this: =IF({ParkingLotBlockedComm} <> "",…
-
Help with an INDEX(MATCH(MATCH( Formula
Hey all, I have two sheets: Business Consult and Project Proposal. I'd like to move specific info from that sheet onto the Project Proposal sheet using a unique identifier, the Business Consult ID. I've mirrored columns on both sheets and they are in the same order (though Project Proposal sheet has additional columns). My…
-
[Need Help] Lookup/Index matching for Horizontal Data
I’m trying to automatically assign a reviewer type (like “Peer” or “Leader”) based on a reviewer’s phone number. The problem is that in my reference sheet, the 20 possible reviewers are listed across columns — each one has a phone number and a reviewer type in a separate column. In my submission sheet, I just have one…