Help on using formulas in shapesheet
Help on using formulas in shapesheet
(OP)
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
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
RE: Help on using formulas in shapesheet
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
RE: Help on using formulas in shapesheet
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
RE: Help on using formulas in shapesheet
John... Visio MVP - Visio.MVPs.org