Multiplying cells from different sheets

JoeS ✭✭
edited 12/09/19 in Formulas and Functions

Sheet 1: Work Scheduled (number of work units scheduled in a given month)

Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month)

I would like to multiply a cell from Sheet 2 with the corresponding cell from Sheet 1 and then be able to copy/paste the formula so that it updates based on cell position in Sheet 2. I can easily do this in Excel, but have no idea how to do it in Smartsheet. Any ideas?


- Sheet 1: Build 10 miles of fence posts in month 1, build 15 miles in month 2

- Sheet 2: At $100/mile, the cost in month 1 is $1000, cost in month 2 is $1500, cumulative cost is $2500

- In Excel, the formula might be [Sheet 2]$B2*[Sheet 1]C2, [Sheet 2]$B2*[Sheet 1]D2, etc. (copy/paste would update the formula based on cell position in Sheet 2)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!