Formula with data from cell out of another sheet



I use two sheets

  • overview insurance policies with current premium in %o
  • portfolio list with insurance sums f.e. 2.000.000,00 EUR

Now, I want to create a formula such as insurance sum (sheet 2) x premium (sheet 1) / 1000 = premium p.a.

Ho can I combine the formula with the cell linking ?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!