I have a drop down list with items that users pick. Is there a way to see which items are left?
I have a drop down pick list with about 90 items. I would like to see which items are left over after a user selects one of the pick list items.
Answers
-
Hi @Mark Neill,
Would it be worth using Automation to move the selected items row to another sheet, then your original sheet should always show what's 'In stock'?
Or you could use Conditional Formatting to change a row or cell when selected, and utilise a 'Sort' to keep available products at the top or bottom.
Cheers
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives