Auto fill from a another sheet

Is there a way to autofill from one sheet to another.

Example:

I have data on one sheet and I am creating a % on another sheet.

So I am linking the cells and dividing by a number in my % sheet.

Is there a way to "drag" the data from the original sheet, so that I dont have to link every single cell individually?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!