Spreadsheet: 873902d1720499929-named-range-data-validation-error-demo
Sheet: Worksheet

Date | Item | Type | Colour | Daily Count | Weekly Count
 |  |  |  |  |  |  |  | Apple - red
 |  |  |  |  |  |  |  | Apple (Golden Delicious)
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Artichoke
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Avocado
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Bean sprouts
 |  |  |  |  |  |  |  | Beet greens
 |  |  |  |  |  |  |  | Beetroot
 |  |  |  |  |  |  |  | Bell pepper - green
 |  |  |  |  |  |  |  | Bell pepper - orange
 |  |  |  |  |  |  |  | Bell pepper - purple
 |  |  |  |  |  |  |  | Bell pepper - red
 |  |  |  |  |  |  |  | Bell pepper - yellow
 |  |  |  |  |  |  |  | Blackberries
 |  |  |  |  |  |  |  | Blueberries
 |  |  |  |  |  |  |  | Broccoli
 |  |  |  |  |  |  |  | Cabbage
 |  |  |  |  |  |  |  | Cabbage - red
 |  |  |  |  |  |  |  | Cantaloupe
 |  |  |  |  |  |  |  | Carrot
 |  |  |  |  |  |  |  | Carrot - purple
 |  |  |  |  |  |  |  | Cauliflower - purple
 |  |  |  |  |  |  |  | Celery
 |  |  |  |  |  |  |  | Chard - green
 |  |  |  |  |  |  |  | Chard - red
 |  |  |  |  |  |  |  | Cherries
 |  |  |  |  |  |  |  | Chicory (radicchio) - red
 |  |  |  |  |  |  |  | Corn
 |  |  |  |  |  |  |  | Cranberries
 |  |  |  |  |  |  |  | Currants - red
 |  |  |  |  |  |  |  | Edamame
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Ginger
 |  |  |  |  |  |  |  | Grapefruit - pink
 |  |  |  |  |  |  |  | Grapes - purple
 |  |  |  |  |  |  |  | Green beans
 |  |  |  |  |  |  |  | Green tea
 |  |  |  |  |  |  |  | Jalapeno pepper - red
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Kale - purple
 |  |  |  |  |  |  |  | Kiwi
 |  |  |  |  |  |  |  | Kumquat
 |  |  |  |  |  |  |  | Lemon
 |  |  |  |  |  |  |  | Limes
 |  |  |  |  |  |  |  | Lingonberries
 |  |  |  |  |  |  |  | Mandarine
 |  |  |  |  |  |  |  | Mango
 |  |  |  |  |  |  |  | Mustard greens
 |  |  |  |  |  |  |  | Mustard greens
 |  |  |  |  |  |  |  | Nectarine
 |  |  |  |  |  |  |  | Nectarine
 |  |  |  |  |  |  |  | Okra
 |  |  |  |  |  |  |  | Olives
 |  |  |  |  |  |  |  | Onion - red
 |  |  |  |  |  |  |  | Onion - yellow)
 |  |  |  |  |  |  |  | Orange
 |  |  |  |  |  |  |  | Orange - blood
 |  |  |  |  |  |  |  | Papaya
 |  |  |  |  |  |  |  | Passionfruit
 |  |  |  |  |  |  |  | Peach
 |  |  |  |  |  |  |  | Pear - Asian
 |  |  |  |  |  |  |  | Pear - red
 |  |  |  |  |  |  |  | Pears
 |  |  |  |  |  |  |  | Peas
 |  |  |  |  |  |  |  | Persimmon
 |  |  |  |  |  |  |  | Pineapple
 |  |  |  |  |  |  |  | Plum
 |  |  |  |  |  |  |  | Plum - red
 |  |  |  |  |  |  |  | Pomegranate
 |  |  |  |  |  |  |  | Potato - purple
 |  |  |  |  |  |  |  | Potato - red
 |  |  |  |  |  |  |  | Potatoes (Yukon)
 |  |  |  |  |  |  |  | Prunes
 |  |  |  |  |  |  |  | Pumpkin
 |  |  |  |  |  |  |  | Raisins
 |  |  |  |  |  |  |  | Raspberries
 |  |  |  |  |  |  |  | Spinach
 |  |  |  |  |  |  |  | Squash (acorn, butternut, summer, winter)
 |  |  |  |  |  |  |  | Starfruit
 |  |  |  |  |  |  |  | Strawberries
 |  |  |  |  |  |  |  | Sweet potato
 |  |  |  |  |  |  |  | Tomato
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Turnip
 |  |  |  |  |  |  |  | Watercress
 |  |  |  |  |  |  |  | Watermelon
 |  |  |  |  |  |  |  | Yams