Formulas not always autofilling

Lisa Vercellone

I have a SmartSheet that I add new rows to at the bottom of the sheet daily. All the rows above the newly added rows have formulas in them. Some days it autofills the formulas into the new rows. Other days it takes several minutes before it autofills them. Most of the time, it does not autofill at all and I have to manually copy and paste all the formulas into the new rows. Any idea what causes this inconsistency?

Thanks, Lisa

Andrée Starå

Hi @Lisa Vercellone

I hope you're well and safe!

Have you looked into making them Column Formulas?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Would that work/help?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lisa Vercellone

I shared the sheet with you. It's the first column Task and then these almost all the way to the right.

This is an inventory to track vaccines that are administered. The check columns compare what was recorded when it was administered to another Sheet that tracks what was received for vaccines. It is very good and finding charting errors this way.

Thanks, Lisa

Andrée Starå

@Lisa Vercellone

Happy to help!

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

Andrée Starå

@Lisa Vercellone

Glad we got it working!

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