When activating "Colum formulas" the Cross sheet references become "invalid ref"

Options

When activating "Colum formulas" the Cross sheet references become "invalid reference".

 The Cross sheet references to a big sheet.


Tags:

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Hi @Francis Dupuis ,

    Did the formula work before you converted it to a Colum Formula? Did all of the cells in the Column have the same formula? If the answer to both of those questions is yes, it would help to see your formula. Please attach a screenshot and/or your formula.

    Happy to help.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Francis Dupuis
    Options

    Hi, the answer to both is yes, here is the formula : =VLOOKUP([Courriel employé]@row; {1.1-Embauches}; 2; false).

    It is a simple formula.

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Your formula looks good. Invalid reference errors occur when a reference name to another sheet (in curly braces) doesn’t exist as a reference to another sheet. To resolve it try creating a new reference and using a different name.

    To avoid the #No Match, add IFERROR to your formula =IFERROR(VLOOKUP([Courriel employé]@row; {1.1-Embauches}; 2; false),"")

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!