Autofill Date with Dropdown Selection

Hey everyone. I am trying to figure out how to make my sheet autofill today's date when we complete a project. We have a status column and when that column is marked "Completed" I want the Completion Date to autofill to today. I tried this:

=IF(Status@row = "Completed", TODAY())

The problem is that it changes the completed date to TODAY'S date every day and doesn't keep the correct completed date - if that makes sense. In other words, projects I marked as "Completed" on Friday filled in with Friday's date ON Friday, but today the projects I finished Friday have today's date as the date completed.

Would love someone's expertise on this.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!