Is this possible? And if so, what formula do I employ? I tried some and
couldn't get it to work. I have a drop down menu that lists several
project types that have pre-defined sizes. Based on their selection, I
want another field to be autopopulated with the size. Some of the
project types do not have pre-defined sizes, so I want them to be able
to input the size they need in the same field. Example: Dropdown Field:
Printed Piece Project Type Choices: Brochure, Kiosk poster, postcard
Calculated ...