Here is how my sheet looks like:
A:Aincludes a series of timestamps.
- for every cell $X
Nwhere X is between B-K and
Nis a number it's value is either empty or equal to $A
Many times when I click on a new cell and press
=, I get the formula I need suggested to me and I can just press enter to fill it, this happens on the columns that already have many sells filled, but when I press
= on a sell of a column that has only a few sells filled I don't get the formula suggested to me.
Is there any way to make a default formula so whenever I click on a sell in those columns I get that formula filled in or at least when I press
= I get it suggested to me?