Issue with Formula Autofill

Joe Miner · 07/27/20

Hello, I am currently trying to make an equation driven total column. Currently I am experiencing issues with the formula not autofilling to the next row.

I have looked at the help page that describes the necessary criteria for autofill to take place. I plan on filling this sheet via a form and so far have been testing with the two or more rows filled out and formulas added by dragging the first row down. From my understanding once a two or more consecutive rows have the same formula the next row added below should auto-populate with the formula. This is not happening and I was looking for help as to why/how I could fix it.

EDIT:

I have embeded an image of what I have been struggling with. I have typed the formula into cell one, dragged the formula to row 2. It does not autofill to row 3.

This is the formula I don't think there is any issue with the formula as it does work.

=IF(COUNTIFS([Labor Cost]@row:[Material/ Vendor Cost]@row, ISNUMBER(@cell)) > 0, SUM([Labor Cost]@row:[Material/ Vendor Cost]@row))

Mike Wilday · 07/27/20

If you have at least two rows of data before it manually delete everything underneath it. Highlight all the rows following your two rows of formula filled column then delete them completely. Smartsheet will create new ones, but they should then use the auto populate feature at that point.

Paul Newcome · 07/27/20

Is the form populating row 3?

Andrée Starå · 07/27/20

Hi @Joe Miner

The new row will be auto-filled with the formulas if there are two rows below/above with the same formulas and the same level of hierarchy.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Joe Miner · 07/27/20

@Andrée Starå @Paul Newcome I have edited my original post to include an image of what I am struggling with and the formula

Paul Newcome · 07/27/20

It should autofill once a new form is submitted. Are you entering any data into the Primary Column?

Andrée Starå · 07/27/20

@Joe Miner

What do you have in the Primary Column?

Mike Wilday · 07/27/20

If you have at least two rows of data before it manually delete everything underneath it. Highlight all the rows following your two rows of formula filled column then delete them completely. Smartsheet will create new ones, but they should then use the auto populate feature at that point.

Paul Newcome · 07/27/20

@Andrée Starå It's happening again. Haha. Same ideas and same questions at the same time. It's my quitting time for today though, so I'll check back in tomorrow to see if it got sorted out.

@Joe Miner Between Andree and Mike, you are in good hands. I'll keep my fingers crossed for you.

Joe Miner · 07/27/20

@Andrée Starå

I currently do not have the primary column filled at all

Joe Miner · 07/27/20

I also have another grouping of columns that are powered by a series of formulas that do currently auto-populate without an issues

NEXT MAINTENANCE formula: =IF(ISBLANK([Maintenance Period (days)]@row), "", ([Last Maintenance]@row + [Maintenance Period (days)]@row))

MAINTENANCE URGENCY formula: =IF(ISBLANK([Next Maintenance]@row), "", IF([Next Maintenance]@row - TODAY() >= 182, "Blue", IF(AND([Next Maintenance]@row - TODAY() >= 31, [Next Maintenance]@row - TODAY() < 182), "Green", IF(AND([Next Maintenance]@row - TODAY() >= 7, [Next Maintenance]@row - TODAY() < 31), "Yellow", IF([Next Maintenance]@row - TODAY() < 7, "Red", "")))))

EDIT: I was under the impression that this was auto-filling properly but I was mistaken there were prepopulated formulas that I had dragged down at a previous time.

Andrée Starå · 07/27/20

@Joe Miner

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Andrée Starå · 07/27/20

@Paul Newcome

Haha!

We need the same feature as in Smartsheet that shows when someone is doing something in the sheet.

Paul Newcome · 07/28/20

@Joe Miner

When you said... "I was under the impression that this was auto-filling properly but I was mistaken there were prepopulated formulas that I had dragged down at a previous time."

Do you mean that you dragged formulas down into (for example) row 3 previously? If that is the case then additional formulas put into rows 1 and 2 won't auto-fill into row 3 because row 3 was already populated.

Try putting all formulas into the appropriate columns in ONLY rows 1 and 2. THEN use the form to populate a new entry into row 3.

Mike Wilday · 07/28/20

Just make sure you that you delete all the rows under the completed two rows. You'll know if this was successful if your form data comes into row 3. If everything was deleted properly you should see the formulas autofill. Just make sure you (or someone else) didn't overwrite the formula in the first or second row.

Genevieve P. · 10/04/20

Hi @Joe Miner,

This week we released a feature called Column Formulas, where you can set one formula for the entire column. It sounds like this feature may resolve your initial issue so I wanted to make sure you heard about it!

See our Help Center for more information: https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Cheers,

Genevieve

Issue with Formula Autofill

Best Answer

Answers

Categories