Adding New Row Auto-Updates Existing Row?
I'm looking for some conceptual help with automating a project flow. I have a master list of copiers with lease expiration date. When a lease expires, I want to build a purchase request form to order a new copier (which should create a new record once complete and received). Is there a way to automatically mark the old record complete (updating existing record) at the same time as adding a new record? Basically, once the new copier is received in Smartsheet, something that goes back to the old copier record and marks it Closed/Returned/Complete?
Thanks for the help!