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

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

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

How to update certain cells in column based on one cell's input and other column's same ID #?
I have a very simple test script testing tracker located here: I want to be able to do one of the following: 1. Update the Status column for all testers with the same test ID to "Duplicate" once one person tests and puts "FAIL" in the PASS/FAIL column. 2. Do not copy defects to defect tracker sheet if one of the rows with…
Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…