Formulas not showing in new rows

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Formulas not showing in new rows

Hi,

Not sure if this is a new issue but formulas in sheets aren't showing in new rows if there is a parent row below it.

The first attachment shows how the sheet is setup and a number of columns have formulas in them.

If I add a row between Test 3 and the Applications Confirmed parent row, it won't pull the formulas down (regardless of how many rows I have above it) and just leaves them blank. They are locked columns so its an issue for end users as the fields don't populate

If I add a blank row (second attachment and the row is only locked so noone can remove it) and then add a row between Test 3 and the blank row, its pulls the formulas down.

Has anyone else experience this? I only noticed it started happening last week

Option 1.JPG

Option 2.JPG

Tagged:

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    Have you tried to add some text to the Primary column on that row? It doesn't activate the formulas if there isn't any information.

    Did it work?

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree,

    Meant to say in my post that adding data into the primary column doesn't pull the formulas down if there isn't a blank row below it

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Ok.

    Is it added as a child to the parent above?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree,

     

    Yes, it is being added as a child to the parent above. 

    I've had to add blank locked rows into my sheets above the next parent as this seems to fix the issue

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Strange!

    I'd be happy to take a look and see if I can discover what's causing it.

    Can you maybe share the sheet(s) or a copy? (Delete/replace any confidential/sensitive information before sharing) (share too, [email protected])

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree,

    Thanks. I'll share the sheet with you shortly.

    If you add a new row below row 16 and put data in the primary column, its doesn't bring the formulas down (they are in the end part of the sheet). However if I add a row between 37 and the blank locked row 38, it brings the formulas down when data is entered in the primary column.

    Its very strange as it always used to work

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Thanks!

    I'll take a look and get back to you!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Glad we got it working!

    Have a fantastic weekend!

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • What was the solution here?

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi, @GELBill

    Fist make sure that the conditions below are met.


    If the formula structure is the same above/below the Formula Autofill will add the formula(s) automatically.

    Conditions That Trigger Formula Autofill

    You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:

    • Directly between two others that contain the same formula in adjacent cells.
    • At the topmost of the sheet if it’s above two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
    • At the bottommost of the sheet if it’s below two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
    • Above or below a single row that is between blank rows and has formulas.

    More info: 

    Did that help fix it?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.