how would I make a template-dependent column update automatically? I have 2 different sheets that I made to relate through the template column, the template column updates itself fine, but it does that only when the other column is updated manually.
I want to know how to do this so that, that dependent column can be updated from the front end or automatically in accordance with increase in rows from the other sheet? @Jeff_Hager
I want the serial column(in the 1st picture) to update automatically as the email column of the other sheet increase (the 2nd picture).