C
craigwojo
Hi everyone,
Could someone assist in doing the following?:
NOTE: Column B (Material) is a validation dropdown menu with options o
BRASS (EMBOSSED), ENGRAVED PLASTIC, STAINLESS STEEL (LASER MARKED)
BRASS (LASER MARKED) & STEEL (LASER MARKED).
Also NOTED:
Column A= Quantity
Column B = Material
Column C = Size & Shape
Column D = Legends
Column E = Color
Column F = Unit Price
Column G = Total Price
If Column B = Brass (Embossed) – then Column C should give you th
option of:
1-1/2” Round
1-1/2” Square
2” Round
2” Square
…and in column E the option for Color will not be usable or the colo
will be blank.
If Column B = Engraved Plastic – then Column C should give you th
option of:
1-1/2” Round
1-1/2” Square
1-1/2” Triangle
2” Round
2” Square
2” Triangle
3” Round
3” Square
3” Triangle
4” Round
4” Square
4” Triangle
…and in column E the option for Color would be:
Black w/White Lettering
Green w/White Lettering
Yellow w/Black Lettering
Red w/ White Lettering
Blue w/White Lettering
White w/ Black Lettering
If Column B = Stainless Steel (Laser Marked) – then Column C shoul
give you the option of:
1-1/2” Round
1-1/2” Square
2” Round
2” Square
…and in column E the option for Color will not be usable or the colo
will be blank.
If Column B = Brass (Laser Marked) – then Column C should give you th
option of:
1-1/2” Round
1-1/2” Square
2” Round
2” Square
…and in column E the option for Color will not be usable or the colo
will be blank.
If Column B = Steel (Laser Marked) – then Column C should give you th
option of:
1-1/2” Round
1-1/2” Square
2” Round
2” Square
…and in column E the option for Color will not be usable or the colo
will be blank.
I hope this makes sense.
Thank you,
Crai
Could someone assist in doing the following?:
NOTE: Column B (Material) is a validation dropdown menu with options o
BRASS (EMBOSSED), ENGRAVED PLASTIC, STAINLESS STEEL (LASER MARKED)
BRASS (LASER MARKED) & STEEL (LASER MARKED).
Also NOTED:
Column A= Quantity
Column B = Material
Column C = Size & Shape
Column D = Legends
Column E = Color
Column F = Unit Price
Column G = Total Price
If Column B = Brass (Embossed) – then Column C should give you th
option of:
1-1/2” Round
1-1/2” Square
2” Round
2” Square
…and in column E the option for Color will not be usable or the colo
will be blank.
If Column B = Engraved Plastic – then Column C should give you th
option of:
1-1/2” Round
1-1/2” Square
1-1/2” Triangle
2” Round
2” Square
2” Triangle
3” Round
3” Square
3” Triangle
4” Round
4” Square
4” Triangle
…and in column E the option for Color would be:
Black w/White Lettering
Green w/White Lettering
Yellow w/Black Lettering
Red w/ White Lettering
Blue w/White Lettering
White w/ Black Lettering
If Column B = Stainless Steel (Laser Marked) – then Column C shoul
give you the option of:
1-1/2” Round
1-1/2” Square
2” Round
2” Square
…and in column E the option for Color will not be usable or the colo
will be blank.
If Column B = Brass (Laser Marked) – then Column C should give you th
option of:
1-1/2” Round
1-1/2” Square
2” Round
2” Square
…and in column E the option for Color will not be usable or the colo
will be blank.
If Column B = Steel (Laser Marked) – then Column C should give you th
option of:
1-1/2” Round
1-1/2” Square
2” Round
2” Square
…and in column E the option for Color will not be usable or the colo
will be blank.
I hope this makes sense.
Thank you,
Crai