Automating Start Date
In my sheet I have a "Start Date" column that I would like to automate. In a separate status column I have a drop down option that includes, "Not-Started", "In Progress", "Completed". Once the status column is switched to "In Progress" I would like the Start Date column to automatically post the current date. Once that date is posted I would like to use that initial date indefinitely, unless the status column is switched back to "Not-Started".
Does anyone have ideas for a possible formula or other solution for this?
Help Article Resources
Check out the Formula Handbook template!