Insert cell reference from a different page

Started by Sonartech, August 04, 2009, 01:45:14 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Sonartech

I am trying to insert a cell reference from the custom properties of a shape on one page into another page.

I have a shape on Page-4 (a background page) that has custom properties set. I want to show one of those properties on Page-5 (another background page).

The Shape ID = 19 and the property I want to display is called Prop.Project

I tried the following:
On Page-4, select the object to show the custom property and then select Insert|Field and then enter the following Custom Formula:
=Pages[Page-4]!Shape.19.Prop.Project

The result gives me a Error in formula message.

I have tried to display various properties from Page-4 without success, so I am wondering if I am using bad syntax for referencing the other page.

Thanks

DavidJT

This is an old post but other may look for answers in it.

The formula was stated to be:

=Pages[Page-4]!Shape.19.Prop.Project

And should instead be:

=Pages[Page-4]!Shape.19!Prop.Project

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 153 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1063KB.
Tokens: post-login.
Cache hits: 13: 0.00131s for 26,597 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]