Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I have one value always selected in the list box.
In the below tables, when I make any selection in the Region, I want APAC to be selected along with my selections. Similarly when I make any selection, in Market Sector, I should have the FI selected along with the selections I want. When I don't select anything from the Region or Market Sector, then it should not select anything. Thanks for the help.
Region  | 
|---|
| North America | 
| APAC | 
| EMEA | 
| LATAM | 
| Market Sector | 
|---|
| FI | 
| ABC | 
| SF | 
| Copr | 
Ok So it is based on Region.Solution provided by sunindia should work
You need this action:
='(' & Chr(34) &'APAC' & Chr(34) & '|' & If(GetSelectedCount(Region) >0, Concat(Chr(34) & Region & Chr(34), '|') & ')', ')')
Perfect. Thanks so much Sunny.