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 Comm…
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…
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…
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…
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…
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?
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…
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 thei…
Hi! any help on why this formula is not working? =INDEX({Operations BOB LON H}, MATCH({Operations BOB Range 4}@row, {Operations BOB Project Code}, 0)) this is a similar formula that we have and it is …
I'm determining how long a person has been parked based on the parking lot zone number and the amount of money paid. I have a separate reference sheet that lays out the zone numbers, location names, a…