How to pull data from another sheet

Options

Ljs346

Ljs346 ✭✭✭

02/06/24 in Formulas and Functions

Hello, I am populating the first two columns (Course Number and FSS Support) from another sheet where the data is already housed. I can't figure out how to set the formulas up. Thank you!

0 ·

Answers

heyjay ✭✭✭✭✭

02/06/24
Options
Use cell link - https://help.smartsheet.com/learning-track/level-2-intermediate-users/cell-linking

...
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

ISO Formula to pull data from one smartsheet to another
I am trying to pull a site number from one smartsheet to another based on the date. So when smartsheet 1 is updated and a site moves to another date, smartsheet 2 is updated. Smartsheet1 Smartsheet2 End Result on Smartsheet2
VLOOKUP Output Doesn't Match Expected Value
Hey Everyone, I've been having a hard time with some missing features or current limitations within SmartSheet but have found the communities helpfulness in finding various work arounds very useful. I'm hoping that somebody will have an idea for the issue i'm currently running into now. Having made some helper columns…
What is wrong with this formula?
I am trying to summarize the quantities of each different sized container that is also checked as being shipped off-site to use in a dashboard pie chart. I tried the following formula, but I get '#unparseable'. What do I need to fix? Or coincidentally is there a better way, using reports, dashboards, however, to visualize…