Column Formula Question


Is it possible to convert a cell formula to a column formula if it references a different sheet?

Here is the formula in question:

=VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false)

Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet. I am currently unable to convert this formula to a column formula and was wondering why?


  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭

    What are you receiving for an error message or issue indicating that it is not allowing you to convert it? You could also try using =INDEX(MATCH()) which is the recommended alternative to VLOOKUP(). It creates fewer cell references.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!