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?
Meg Young
mmyoungconsulting@gmail.com
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives