×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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

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