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 to SUM = 0 Why?
I created a formula to sum the values in other formula columns but the return is "0". I have created other sheets with the same type of formula and the return is correct. How is the return 0 on this formula. It appears to be correct.
Label Status Dot Help
Hey all! I am trying to add the color symbol dots to align with status and I've tried so many formulas, I cannot for the life of me figure this out. Nothing crazy in this sheet, just want to align the status to the color of the dot. If Status = Complete —> Green If Status = In Discovery, In Process, In Review —> Yellow If…
Formula Help
Hello, I feel like I am close with the current formula I am using in a build out. Could use some help if anyone has suggestions. I have a section where AutoFail is possible and then a Section that is Pass/Fail based on %'s. If they Pass the Pass/Fail Portion but Auto Fail the other portion the entire total score is Auto…