Sure @Jen_NYCP, I do this all the time using GSheet ARRAYFORMULA.
ARRAYFORMULA is used when you need to place a formula in the first cell os a column and what that formula to be repeated in every cell below.
For example, if I need the content from every new cell in column B to be “New”, I can use something like that on the B2 cell (assuming that B1 is the header):
=ARRAYFORMULA(IF( A2:A = “”, “”, “New”))
This will check if A2 to the last created A cell has any content, if its blank, nothing happens but if has anything, the value in B will be New for each valid row.