Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two fields Product category and Product...We have seperate sheet for each category and have default selections while opening the sheet...
While opening the Cat1 sheet, Product which comes under Product category="Cat1" will be selected. We have 15 Products under "Cat1" and totally 50 prodcuts...
And in the current selection it is showing like Product: 15 of 50...
Instead of showing the number(15 of 50) can we show the text like "Cat1 Products" in the current selection...
Hi,
Current selections shows what has been selected in the chart.
May be you can add Help to the current selections and add the following comment -
=Category & ' Product is selected', so that it will dynamically show which product category has been selected.