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

Formula need to return Pass/Fail if 1 of multiple cells are blank
Hi, I am trying to put a formula together that will provide a fail if any part of the address or the phone number hasn't been provided. The below formula only provides fail if all cells are blank. I have tried other variations, this is the only one that does not give me some sort of error. =IF(OR(NOT(ISBLANK([Street…
Combining AVG/COLLECT/NETWORKDAYS
I am attempting to calculate the average number of working days it takes to complete a request, Criteria I want to base the data collection on include: urgency level Month and Year(I created a rolling month chart to see trends-see below screenshot) The Work Completion Date determines the month it will be reported on This…
CountIf Function
I want to count the number of each option in this example; Change Router, Upgrade, Disconnect. My Objective column is set up as a drop down with allow multiple values enabled. My formula is only calculating Row 5, because that is the only row with only one value. How do I get my formula to calculate each drop down option…