Is it possible to insert a 'Name' in Pages?

Hello Ken,

Thank you for the details of the issue you are experiencing with creating a formula that references a data in a different table. To reference the data in the different table, you will just need to click on the cell in the alternate table when building the formula:

Add, subtract, multiply, or divide values

You can create simple or complex arithmetic formulas to perform calculations on the values in your tables.

1. Click the cell where you want the result to appear, then type the equal sign (=).The formula editor opens. Drag the left side of the formula editor to move it.
2. Select a cell to use as the first argument in your formula, or type a value (for example, a number such as 0 or 5.20).
3. Type an arithmetic operator (for example, +, -, *, or /), then select a cell to use as the next argument in your formula, or type a value.By default, + is inserted between cell references.
4. Continue adding operators and arguments until your formula is complete, then press Return or click in the formula editor when you’re done.If you click , you exit the current cell without saving your changes.

In step 2, just click the cell from the alternate table to reference that cell in your equation.

Calculate values using data in table cells

http://help.apple.com/pages/mac/5.0/#/tana41710df7

Thank you for using Apple Support Communities.

Best,

Sheila M.

Hi kenem,

Thank you for the additional information. Due to the nature of your issue or question you may find more information by using another one of Apple's support resources - https://getsupport.apple.com/GetproductgroupList.action

All the best,

Sheila M.

Sheila

Is this a new feature in Pages 5, being able to reference values in one table from another?

If so I would like to know where it is revealed in the UI. I have not been able to find it.

Peter

Which version of Pages are you using?? It looks like you are on Snow Leopard so it should be Pages 09 or Pages 08.

Pages 5 is pretty much worthless for serious work- dozens of critical and basic features missing. Just save yourself headache and go back to Pages 4.3, which should still be in an iWorks folder within your Applications folder.

Please remember to tell Apple what we need from them at:

http://www.apple.com/feedback/pages.html

And rate on the App Store!

Sheila-

Nice to see that you guys are at least on here. Can you acknowledge that you're understanding the commentary?

Hello Ken,

I'm not sure if these future updates will address your specific issue, but this article does have some additional information on the new iWork products you might be interested in:

About the new iWork for Mac: Features and compatibility

http://support.apple.com/kb/HT6049

Thank you for using Apple Support Communities.

All the best,

Sheila M.

Sheila

We are really curious, as just about every Apple person we meet never uses iWork and instead is on Ms Office, are you just reading this from knowledgebase notes?

Peter

It is unlikely that it would be possible. If you import a Word document with cross referencing of tables, the cross reference is deleted, isn't it? That is a good indication that one cannot enter it manually in Pages.

In earlier versions, I tried to do some clever things with Applescript, but even there it was fairly clear that it would not work.

Ken,

This is a victory for Pages users; Tables being able to reference other Tables in Pages. For all that was lost in the upgrade, we must give this particular feature gain its due.

I don't see any way to name tables, but they now do have names and you can use them to reference from one table to another. Since the names aren't displayed in any way that I have located, I suppose that you are supposed to use the point and click addressing technique when building expressions. To learn a table's name, use point and click to reference it from another table and make a note of the name that appears in the expression you are editing.

Jerry

Jerry

Is that a definite?

A cell in one table can reference a cell in another table?

If so can you give a step by step, I'll put it in the Pages 5 Additions.

Peter