Scripts, scripts, scripts!

[Eric_Penn]

I think this script from @Uzo could help you.

Replace Add Rows by Set Columns to trace user clicks. Your Best Practices pls for the least nb of rows

I gave you a link to my script, just copy it and paste it onto the script editor in google sheets… don’t forget to add on change trigger by clicking the clock icon or in the old version … edit tab… current projects triggers