×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help on using formulas in shapesheet

thread172-1373882

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

RE: Help on using formulas in shapesheet

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

RE: Help on using formulas in shapesheet

(OP)
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

RE: Help on using formulas in shapesheet

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close