-
Some parts of the automation not running based on Index(Match) cell change
Hi folks, Could I get some help with this issue, please? Published sheets shared below. Workflow: Order Form Sheet - lists items (Primary column), has a Submit check box column (box is checked), and has a status dropdown column with an INDEX(MATCH) formula referencing the Tracking Sheet. Rows are locked. Tracking Sheet -…
-
Index match on multiple sheets
Apologies if this question has been asked, I wasnt sure how to search for this within the community. I stumbled across this formula using the AI formula builder which sort works but not sure how to fix it, its when the simple formulas start stacking is when im getting lost in how they work together. What I have is an…
-
INDEX MATCH Formula
Hi, I used this formula in one column on Sheet 1, it looks at Sheet 2 and finds the Site Name and if the Status is Committed, it pulls in the number of Committed Trees. It works just fine for the Committed Trees column. =IF(INDEX({Inventory Agreements - Status}, MATCH([Site Name]@row, {Inventory - Site Name}, 0)) =…
-
IF Row @ Column A=Column B, then return Column C
I have 2 sheets. Sheet A to track the orders: Order IDs (column 1) and the Services (column 2) of those Order IDs. Sheet B to track the hours works on the orders: Order IDs (column X) and the Services (column Z) of those Order IDs. I am trying to use a formula that says: If Sheet A Order ID@row equals Order ID@column A on…
-
Help with Index/Match + if blank
Hello, I am trying to create a formula for one sheet to search another sheet based on a PO#, and return the value of the latest PO revision. I'm trying to make this work without adding a helper column to the sample data sheet. Here is sample data: The result I want in a separate sheet: I came up with two possible solutions…
-
Pull Cells Only From Another Sheet With Criteria
Good afternoon all, I am trying to figure out how to have certain cells pulled over to a row on a new sheet when certain criteria are met. I want the purchase order number in the purchase order column to pull onto another sheet only if the REQ # matches. The purchase order number shows up in the purchase order column that…
-
Index/Match Formula Referencing Contact Columns Providing Wrong Values
I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for…
-
Formulas with INDEX and MATCH function now showing #NOMATCH
All of my columns that are using the INDEX and MATCH function are now showing as #NOMATCH. was there a change made in Smartsheet? what will i have to use now instead?
-
Index/Match Formula Behavior
Hello, I'm encountering an issue with the INDEX/MATCH function. When the value in the cell being match does not find a match and is recognized as text rather than a number, the formula does not return 'no match' as expected. Instead, it displays the last entry in the reference range. Formula in cell Category Index/Match…
-
Index/Match Formula
Hello, I am needing advice on using this cross sheet formula to produce values in a cell. I have one sheet that is populated by responses to a form. I have another sheet with a list of people and their contact details. As the form responses come in to the sheet, I would like their answers to also populate on the other…