Here is how my sheet looks like:

  • Column A:A includes a series of timestamps.
  • for every cell $XN where X is between B-K and N is a number it's value is either empty or equal to $AN-$A(N-1)

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?

  • Hey, can you share a dummy sheet ? – pjmg Mar 18 at 16:33
  • 1
    You should be aware that sharing your spreadsheet will unavoidably expose your email address. – Tedinoz Mar 31 at 10:49
  • @Tedinoz thank you so much! – yukashima huksay Mar 31 at 16:46
  • @yukashimahuksay Just let me say that this still means that you need to supply information to better explain your data, how it is laid out, what you are trying to achieve, etc. Like _it's value is either empty or equal to $AN-$A(N-1)_ is pretty vague and could be helped by including a screenshot. _ I get the formula I need suggested to me_ And you need to explain what they formula might be. You also have an obligation to do your own research. Would you please edit your question to describe the research that you did before you posted this question. – Tedinoz Apr 1 at 2:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.