Auto date stamp with drop down list?

**gavster** · 02-18-2009, 07:20 AM

I'm producing a new spreadsheet to track issues and thier completion.

I've used the code I have on another spreadsheet, that I got off this site, thanks.

What I would like to change are the following:
1) The status column (F) uses a drop down list, located in cells Z1 to Z5.
When an option is selected, the date updates in column G automatically.
What I would like is for the date to only update in column G if the drop
down list is changed to Completed.

2) If the status is changed to completed by mistake, and then changed back
I would like the date to disappear.

Finally, can I make the date columns jump automatically so the person entering the data goes from column F to column H.

Many thanks,
Gavin.

**royUK** · 02-18-2009, 07:41 AM

Is this what you mean?

Please Login or Register  to view this content.

**gavster** · 02-18-2009, 08:17 AM

Roy,

Yet again you amaze with your simple brilliance.

Works like a dream.

thanks very much.

**royUK** · 02-18-2009, 08:24 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved and thanks for the rating

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**Racheliz** · 09-19-2017, 08:46 PM

I'm interested in developing a similar spreadsheet, but with the date/time stamp loading to a specific cell based on the Status selected. For instance, Action Started would record a date/time event in column G, then Action Completed would record a date/time even in column H. Please let me know if anyone knows how to add this functionality to the spreadsheet. Thank you

**FDibbins** · 09-19-2017, 11:11 PM

Racheliz welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.