Help with tracking dates
Hi,
I have a drop down 'Action Owner' column in a sheet and I need to track the number of days the action has been on that team. The column could be changed to a team such as Engineering more than once.
Could anyone advise me on the best method for recording this data?
Thanks!
Answers
-
You would need to set up a record a date automation triggered when the Action Owner changes and then in another column use a formula to subtract the recorded date from TODAY().
-
Thanks Paul.
I didn't explain what I need that well, I will try and explain better.
Say the AO is on Materials and has been for 10 days, the AO then changes to Engineering. I need it to record the 10 days in a Material Days column.
It could then be on Engineering for 10 days, and could change back to Materials again. The 10 days would then need to be recorded in Engineering Days column.
If it were on Materials for 10 days again I would need it to add the 10 days on to the existing 10 days in the Material Days column making it 20.
Basically, I need to track the number of days each part spends under each department.
-
This is possible. I have done it before, but I am struggling to explain it here. Give me a little time to review my existing solution and put together some screenshots, and I will get back to you.
-
Thank you, I appreciate your help!
-
Hi @Paul Newcome, just wondering if you managed to get those screenshots? :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 361 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!