Input the date for a multi-select dropdown

Hi all--
I am trying to create an efficient way to track my samples as they move around to different facilities. Please see my screenshot for what I am working on. Ideally, I'd like to just have the check box as in the screenshot because it's easier and faster. Space on my SmartSheet is also a premium.
Now, I'm aware that I can see the date that I updated sample status by checking cell history. What I would like is a secondary way to access that information that doesn't disappear later. Something like date columns for TO SEW, FROM SEW, so on. When TO SEW is checked the date is put into the TO SEW column. When FROM SEW is checked the date is put into the FROM SEW column.
I've copied a formula template that allows me to input TODAY into a different cell when TO SEW is checked. But if I then if I later check FROM SEW, the date would change or disappear. If you see in the screenshots, I can get TO SEW to work, but then when I add FROM SEW everything is lost.
Answers
-
@R0b1n Have your tried using automation to record a date when triggered?
________________________________________________________________________________________________________________________
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Meg Young mmyoungconsulting@gmail.com. Certified in Core Product, Project Management, and System Administration
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 450 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives