I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one sheet from an automation on another.
I use a date/time based automation to copy pertinent cells from one of my sheets (that contains some open cells and some cells linked from another of my sheets - the Master Sheet) into a sheet/process owned by another team in our organization as a 'new row'. Part of the row is a 'status' cell (a drop down) that I push into the other sheet with the value 'open'.
That team 'does their thing' and eventually that cell gets changed to 'Approved' (or denied or a couple of other statuses) and it's this change I would like to get all the way back to the Master Sheet. There is a unique ID that could be used as a filter/identifier to make sure its the right row in the Master that is getting the change.
Maybe I could create further 'shadow sheets' and get cute with linking etc, but a nice simple "change a cell on another sheet" automation would be perfect!
What do folk think?