Anyone know if this is possible in Google sheets? Also, one thing I always find challenging when applying formulas to a column is applying it to the entire col

Anyone know if this is possible in Google sheets? Also, one thing I always find challenging when applying formulas to a column is applying it to the entire column. Either you remember to copy and paste it when you add a new row, or you drag it down to row 10000 and then have a bunch of formula errors because your data doesn’t have that many rows. Or add if(empty()) prefixes which makes them much harder to read. Any better way around that?