Can I restrict edits to a specific column until a resource is assigned?

I am working on a sheet that contains Maintenance tickets (each row is a ticket) and would like to make it that the status of the ticket ("Status" column) cannot be changed from to "Complete" until a resource has been assigned to the row. Is this functionality possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!