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
Paul Reeves. MBA, LSSBB
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives