Change cell value from a Manual Send Update Request
I'm working through a sheet where a team receives the result of a form with attachments. The team then reviews what was provided and does a manual send for update within the sheet to notify the person that filled out the form that they are missing info (could be multiple things that were expected).
The sheet has a status field (assigned, Pending additional info, form approved, completed etc..) . The assigned is done via automation pending the state selected on the form.
The part I'm trying to figure out is if there is a way to change the status from Assigned to Pending Additional Info automatically if the team does a Manual Send for Update within the sheet. I know they can just manually change it but just exploring all options.
I don't have any other trigger currently that I can check against to make that change.