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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!