How to import data from another sheet

Mr. Cordero

I am very fluent with Excel but find that it doesnt work completely the same with Smartsheet. I am trying to import data from another Sheet i.e. 

 

Sheet1 

A1= 200

 

Sheet2

A1='Sheet1'!A1

 

How do I do the same thing with Smartsheet and then hide the formula?

Heidi Decker

Hi Mr. Cordero,

In Smartsheet you would link from one sheet to the other. You can link one cell at a time or you can do ranges. There are 2 ways to do this. You can right click and choose Link from cell or there is a link button on the left side under the Highlighter button where all the other buttons are. There is also a lot of information regarding linking within the community.

I hope this helps,

Peace!

Tim Meeks

True.. the syntax between SS and Excel are different, but SS supports MANY Excel formulas. If you just trying to 1) import a sheet; 2) create a formula and 3) Hide a formula. Then See the links below.

I've created many formulas in SS and have then ususally in columns to the far right on the sheet. I've learned to LOCK the columns and then have in my column title : "Function performed - FORMULA - DO NOT DELETE - COPY DOWN"

 

http://help.smartsheet.com/articles/504553-importing-files-to-create-new-sheets

 

http://help.smartsheet.com/articles/775363-using-formulas

 

http://help.smartsheet.com/articles/504696-hiding-unhiding-columns

 

hope this helps.