Help on using formulas in shapesheet

[rlhawk]

I created a shape that has the following fields: description, manufacturer, part number, cost.
The description field is a variable list that work fine. When i pick a one of the options from the drop-down box in the description field i would like to have the part number filled in based on the description that is selected.
In the shape data sheet for the description valve it shows - INDEX(1,Prop.Description.Format)
I need to know what formula to enter in the part number. I tried - =IF(Prop.Description="yellow car","456","99")but it does not work.
Can someone tell me what i am doing wrong?
Thanks

 

[VisioMVP]

Let me do an example, for a custom property (now called shape data) called Parts, the custom property would have the folowwing features: Type = 1, Format = "Red;Blue;Green" and a value of index(0,prop.Parts.Format)
Create a User defined cell called parts with a value of index(lookup(prop.parts,prop.Parts.Format),"Part 1;Part 2;Part 3")

The user cell will use the Format cell of the custom property to get an index into the custom property. This index will then be used to get a text (or numeric) item from another list.

John... Visio MVP - Visio.MVPs.org

 

[rlhawk]

John,
I appreciate the help. Your example worked just like you said.
I am new to forum's. If i need to ask a question about editing an existing shape do i need to post a new thread? I have never used Visio and i will probably have more questions related to shapes, especially using and editing existing shapes.

Thanks

 

[VisioMVP]

To make it easier for people to follow or find threads, the general rule is to start a new thread if it does not apply to an existing thread. If the questions are refinements on the existing question, then add them to the thread.

John... Visio MVP - Visio.MVPs.org