Hi everyone,
Thanks for your messages and support - very much appreciated all the good ideas 
I had the same issue on Google Sheet, and this is the script I used via Script Editor:
Now the question is how to make this work on Coda? 
Looking forward to your comments.
Thanks again for your help 