Formula is changing at Save

LDLValentine

Here is the formula as Written:

=INDEX({Req Main Sort Summary}, MATCH($[LIBID]@row, {LIBID}, 0), MATCH([Script]$1, {Req Main Sort Header Row}, 0))

Here is what happens when I save it:

=INDEX({Req Main Sort Summary}, MATCH($LIBID@row, {LIBID}, 0), MATCH(Script$1, {Req Main Sort Header Row}, 0))

This is consistent, it will not hold the formula as written.

Paul Newcome

That particular error means that you have a {Cross Sheet Reference} that hasn't been set up properly.

The easiest way to figure that out is to click anywhere within a {Reference}. In the formula helper dialog box that appears when typing out formulas, the little blue link should read "Edit Reference". If it reads "Reference Another Sheet", then you will need to remove that {String} and follow the appropriate steps for inserting a cross sheet reference.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Paul Newcome

Column names that do not have spaces, numbers, or special characters do not require square brackets, and Smartsheet will automatically remove them. It will not cause an error.

LDLValentine

Thank you. That answers part of the question, of course. I had to go back and look at a couple of my other cross sheet Index/Match groups instead of relying on the one I was using. I am still getting a #INVALID REF result that I cannot find the answer too, which I thought was being caused by the above problem. Now I am at a complete loss.

Paul Newcome

That particular error means that you have a {Cross Sheet Reference} that hasn't been set up properly.

The easiest way to figure that out is to click anywhere within a {Reference}. In the formula helper dialog box that appears when typing out formulas, the little blue link should read "Edit Reference". If it reads "Reference Another Sheet", then you will need to remove that {String} and follow the appropriate steps for inserting a cross sheet reference.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references