Auto-generate date/time field data based upon existing column


I have a sheet where I have a Status column. When I chose "complete" in that Status column, ideally I'd like to have another column (let's say it is named "Completion Date/Time") to auto-populate with the date/time (preferably just time) that "complete" was chosen from the Status column. This seems like an easy ask, but I'm not seeing if/how that's possible. Has anyone else run into this?

Thanks in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!