It is not possible To achieve this by using formulation but it surely's doable by making use of Google Apps Script, extra specifically you'll want to make use of a on edit result in. So, that can assist you comprehend what else is wrong with auto generated information, in this https://archer2us42.blogchaat.com/37468211/the-fact-about-auto-generate-that-no-one-is-suggesting