Jan 14 2020 02:47 PM - edited Jan 14 2020 02:48 PM
Hello,
I have a spreadsheet with a "status" drop down and I would like to see if there is a way to be able to track how long it has been in certain statuses. For example, when a record is first added it would have a status of "Unassigned" and I want to track how long it was in this status before it went to a status of "Under Review" and then how long it was in this status before it went to a closed status.
I hope what I am trying to do is clear and appreciate any help.
Thank you
Jan 19 2020 07:02 AM
Jan 20 2020 12:40 PM
Hi @PascalKTeam,
I think a macro solution would be good. I have dabbled in macros and was looking around online initially how to do this, but did not find something that was the similar to what I need to do.
Are you able to give me some suggestions on how to do this with a macro?
Thank you!
Jan 20 2020 01:05 PM
Jan 20 2020 11:17 PM
Hi @szub_2
The attached file shows the principle of how this can be done. just play around with it by changing the status dropdown in the yellow cells. I hope this helps
Jan 21 2020 08:09 AM
Hi @PascalKTeam,
Thank you for file. I think this should work for what I am trying to do. Did you use a macro and Visual Basic? I am trying to replicate and I am not getting the same results. Both dates for Under Review and Unassigned change when I update the status.
Will you please give me some detail of what you did to get the result?
Thank you!
Jan 21 2020 08:17 AM
Hi @szub_2
Yes, I used VBA. You can look at the code by pressing Alt+F11.
For me it works fine, see attached video
Jan 22 2020 07:34 AM
Unfortunately, I am not able to view your video. I could get your file to work, but when I tried to recreate myself, it was not working.
Thanks - szub
Jan 22 2020 07:40 AM