Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
i have a sheet in which i'm using a filed country
Country
India
Japan
China
There is no data asociated with china in my sheet so in default when user sees he should see only india and japan as possible selections and china should be grayed out
how can i do that
May be add a trigger to select those Countries where the data is available?
on sheet1, i show only india and japan data
on sheet2 i show only china data
so when i open sheet 1 china should be automitically grayed out (it indicates the user thata there is no chance of selecting china on sheet1)
when i open a shhet or document i want this to happen china should be automatically greyed out
may be try expression in your list box instead of field like this?
=if(Country<>'China', Country)
This should work!!
Similarly on other sheets you can restrict other field values
its not working
Instead going through the triggers why you are not creating the custom list box with the values that you are needed.
in sheet 1, create the list box with expression
=aggr(if(match(Country,'India','Japan'),Country),Country)
in sheet 2, create the list box with expression
=aggr(if(match(Country,'China'),Country),Country)
So in sheet 1 user will not be able to see the China in list box
user wants to see china but this way