Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula for creating value dependent select lists

Topic Labels: Formulas
170 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all,

I have a field called CATEGORY with Single select values like "Alcohol, Snacks etc ". For each of these values I want to maintain a SUB_CATEGORY field for example : For Alcohol, sub categories may be Beer, Gin, Whiskey. For Snacks, Sub categories may be Chips, Pringles.

Now my requirement is: I want to create a formula that reads the CATEGORY and only displays the relevant sub categories for that category in the drop down. WHat is the best practise to achieve this.

Thanks a lot in advance.

Regards
Sushmit

0 Replies 0