Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help on using formulas in shapesheet

Status
Not open for further replies.
rlhawk

rlhawk

Technical User
Joined
Jun 1, 2007
Messages
6
Location
US
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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MattGreer
  • Locked
  • Question Question
Obtaining data from the ShapeSheet - Dimensions of a pipe
Replies
0
Views
429
MattGreer
MattGreer
MrMode
  • Locked
  • Question Question
First tentative steps with Visio - finding a shape's data based on the value of another shape
Replies
0
Views
517
MrMode
MrMode
collierd2
  • Locked
  • Question Question
Cant display the header of footer in Visio 2007
Replies
0
Views
630
collierd2
collierd2
jimoo
  • Locked
  • Question Question
Comments do not show when hoving over object in 2013
Replies
0
Views
407
jimoo
jimoo
cjbrown815
  • Locked
  • Question Question
Drawing lines in the background
Replies
3
Views
901
VisioMVP
VisioMVP

Part and Inventory Search

Sponsor

Back
Top