This is a rookie question about a schedule app I’m creating for a print shop. I’m using one Google sheet.
There are 4 departments (columns): Design, Print, Mail, and Bindery. I’ve set each department to log in based on employee email. Each department has an enum to select as they progress through the job: Proof, Done, Issue, and each department has a datetime to log the activity when they update their progress.
My question is, how do I set the datetime column to change only if, say, the designer completes their task to “Done”. Right now all of the other datetime columns are changing as well. Please let me know if you need more info.
Thank you for your help.