Hi all
Please forgive my ignorance, I am relatively new to Excel in this capacity and despite my efforts the find the answer online; I cannot seem to figure this out! Your help is greatly appreciated.
In column D I have a list of current job status. I need a formula to automatically populate the date each status was selected from the list into corresponding date columns "G, H, I, J & K".
For example, when the status "Complete" is selected in cell D2, populate the date in column J2.
I hope the image attached will help.
Thanks!
Please forgive my ignorance, I am relatively new to Excel in this capacity and despite my efforts the find the answer online; I cannot seem to figure this out! Your help is greatly appreciated.
In column D I have a list of current job status. I need a formula to automatically populate the date each status was selected from the list into corresponding date columns "G, H, I, J & K".
For example, when the status "Complete" is selected in cell D2, populate the date in column J2.
I hope the image attached will help.
Thanks!