Formula with data from cell out of another sheet

Joerg Schmidt

Joerg Schmidt ✭✭✭

11/17/20 in Formulas and Functions

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 ?

0 ·

Best Answer

Stefan ✭✭✭✭✭✭

11/17/20 Answer ✓

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

Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
5 · Share on Facebook Share on Twitter

Answers

Stefan ✭✭✭✭✭✭

11/17/20 Answer ✓

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

Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
5 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

VLookup help
HI. I need to look up a # based on the entry entered in one column. I have established a look up table, but having a difficult time with the formula. example - I enter ACME Supplies and I want it to look up the vendor number in the table and return the value into the corresponding field.
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…