How do I create a column or what is the formula that will automatically add the date based on a single selection in a previous column? For the date, I just need Month / Day / Year, not time.
Column A single select choices are: New / Pending / Closed.
Column B is the date when I select Column A- NEW,
Column C is the date when I change Column A from NEW to PENDING,
Column D is the date when I changed Column A from NEW or PENDING to CLOSED.
(I do want to be able to see all three dates which is why I’m using Columns B, C and D vs. have the date change in Column B.)
Thanks, Pat Barron