how can i reference a column from one sheet to another?

Options

johnnipearson

johnnipearson ✭✭✭

02/09/24 in Formulas and Functions

Hi Everyone

Does anyone know a formula I can use to reference 1 column from a source sheet to a separate sheet?

Thanks

Tags:

columns

0 ·

Answers

Carson Penticuff ✭✭✭✭✭✭

02/09/24
Options
Your are looking for cross sheet references. Take a look at this article and then someone can help you with any specific questions you have.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula to flag overdue tasks
I've got a formula that flags overdue tasks, but it flags every task with no date. Is there a way to omit nulls? =IF(Status@row <> "Complete", IF(Finish@row > TODAY(), 0, 1))
Help with a Formula?
Hi, I am working on row of dates and I am trying to get the next due date (from today) in another column. I have tried a couple of formulas but get #UNPARSEABLE. What should the formula be? I am looking for the formula for the cell in yellow.
CountIF Formula with Criteria
I have a formula to count how many stores an owner has in our system. It is working great: =COUNTIF([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row) (You can see John Voskamp has 91 stores). I need to determine of the store count, how many are "Open".…