Formula not auto-populating

Options
moskal
moskal
edited 12/09/19 in Smartsheet Basics

Hello, 

I have attached 2 images. One shows how if I insert a row between text in the first example, it auto-populates the "Evolve Tech & Touch", which is just a reference formula.

In the 2nd image, if I insert a row directly below the last one with that formula, it does not auto-populate it. I thought formulas should copy through the row directly below it. Can you assist?

SS1.PNG

SS2.PNG

Comments

  • Schiff A.
    Schiff A. Employee
    Options

    Hello,

    Judging from your post and screenshots, I'm assuming that the reference formula that is populating "Evolve Tech & Touch" is a specific cell reference and not a conditional reference.  This looks like it is also applying to the "PICS Organizational Design" row.

     

    Based on this assumption, the test you're conducting in the second screenshot is not a situation where autopopulating would apply because the formula in the row above the inserted row is different than the row below the inserted row.

    You can work around this by adding a blank row in between each section as a buffer so that when you add a row to the bottom of a section, there are 2 like rows above and a blank row below which would trigger the autopopulate feature.

    https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

     

    Thanks!

    Schiff

    Smartsheet Support