Hi, i use data column to generate List dropdown. It is possible to add, delete or update only one entry in one column ? or need i to configure 1 sheet for each column ?
I think you need separate sheet
You could have one table called ENUMLIST with two columns, category and item… Then in your valid if for each, drop a filter on the category… Then you can add/remove to your heart’s content
@Grant_Stead Then it is possible to add only in one column ??? i don’t understand how to …
Yes, the table would look like: cl.ly - Image 2018-03-29 at 1.02.57 PM.png Image 2018-03-29 at 1.02.57 PM.png cl.ly
@Grant_Stead OK it’s like standard. Only possible to add an entire line. THX
Then elsewhere throughout the app if you want to use those items, you simple filter the table down using the filter… And you would put this filter in the valid_IF FILTER(ENUMLIST, [category] = “Fruit”)
wtf is that CloudApp Comments/chat thing on the image you posted here?
What’re you doing with CA?