I would like to set a date "Completed" based on a status of " Completed"


I have a status column and one of my choices you can pick is "Completed" . When you pick "Completed" I want to set the date in the next column to the date that "Complete" was selected and I don't want the date to change once it is set unless the status changes from "Complete"

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!