Cross Reference

Can you have some rows reference one column in a sheet and other rows reference a different column in the same sheet? It seems like I am getting a message that when I reference a column all 1000+ cells are changed to that reference, but I have 26 rows I want to point to a different column. Do I have to relocate them to another sheet?

Also weird glitch...I have two columns that keep changing from text to date when a save or a new reference comes across about 1/4 of the time causing my columns to blank out. Has happened about 20x in the last 2 days.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Ok. So it sounds like you are clicking on "Edit Reference". Instead... Highlight the entire reference so that the cross sheet link in the formula helper box reads "Reference another Sheet". Then try selecting the new column from your source sheet.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!