Formula with data from cell out of another sheet

Joerg Schmidt

Hallo,

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 ?

Stefan

Hello @Jörg Schmidt Novum Hospitality,

seems like you should check this out:

https://help.smartsheet.com/learning-track/smartsheet-advanced/cross-sheet-formulas

Hope this helps

Stefan

Stefan

Hello @Jörg Schmidt Novum Hospitality,

seems like you should check this out:

https://help.smartsheet.com/learning-track/smartsheet-advanced/cross-sheet-formulas

Hope this helps

Stefan