How to autopopulate today's date in a column

Mary Vogt
Mary Vogt ✭✭✭✭✭

I would like to know if I should use a formula and where, in order to do the following:

When one dropdown menu choice is selected (in this case, 'incomplete'), the date column populates today's date automatically within that row. It doesn't seem that complicated, but yet a workflow doesn't appear to be the way to do it, nor do I think I can do it with conditional formatting? Thanks for any help.


Best Answer