How do I reference different columns from another sheet in different formulas?

Marya

I am creating a sheet with formulas that include ranges in another sheet. The ranges are defined by column. It seems I can reference only one column across all formulas in my sheet. Whenever I go to change the range in one formula, it automatically plugs that same range into the other formulas. How do I create multiple formulas in my sheet that each reference a different column/range in the sheet from which I am pulling the data?

Andrée Starå

Hi Marya,

Here's an excellent resource.

https://help.smartsheet.com/learning-track/smartsheet-advanced/cross-sheet-formulas

Hope that helps!

Let me know if you have questions!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Marya

That helped--thanks!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée