Set Value of Field triggered by value of another field
I'd like to create a script that is triggered by the value of another field. Once a user selects a certain value from a drop-down list, I'd like another field's value to be set to the value of yet another field.
Basically, I have a field that has data entered from an import indicating who this element of production is assigned to...call it AssignedUser. I have another field for the Status that is a drop down menu. Once they select "Complete" from the Status dropdown, I'd like another field, call it CompletedBy to then be populated with the value from the AssignedUser.
Any insight would be greatly appreciated.