It truly is not possible To do that by utilizing formulas nonetheless it's attainable by using Google Apps Script, more specifically you'll want to utilize a on edit bring about. Different way had been to utilize CMake. Just glimpse via this tutorial. You only really need to specify your sources https://rowannbeio.blogrenanda.com/43872196/the-5-second-trick-for-auto-generate