Summary formulas not working while using data uploader.

Jacob Waldrop

I am trying to use data uploader to populate a sheet. It seems to work fine as far as merging the information, however, the formulas in my sheet summary do not work. See before and after using data uploader below.

Andrée Starå

Hi @Jacob Waldrop

Can it be because the range is set between specific rows?

Have you tried changing them to reference the whole column instead.

Would that work?

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!

Mike Wilday

yes, that is extremely helpful.

You can remove the row numbers from those formulas to make the formula dynamic!

Try: =SUM([1-30]:[1:30]) to always grab the entire column no matter how many rows there are. Just make sure you don't have any summary data in the column itself. Keep all that data in the sheet summary. :)

Does that work?

Mike Wilday

Hmmm. What are the formulas you're using? Can you share them so we can see how they're constructed?

Jacob Waldrop

Hi Mike

Will the screenshot below give you what you need? Basically the same formula in all of summary fields.

Andrée Starå

Hi @Jacob Waldrop

Can it be because the range is set between specific rows?

Have you tried changing them to reference the whole column instead.

Would that work?

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!

Mike Wilday

yes, that is extremely helpful.

You can remove the row numbers from those formulas to make the formula dynamic!

Try: =SUM([1-30]:[1:30]) to always grab the entire column no matter how many rows there are. Just make sure you don't have any summary data in the column itself. Keep all that data in the sheet summary. :)

Does that work?

Jacob Waldrop

Referencing the column seems to have worked. Thank you both for your time and insight!

Andrée Starå

@Jacob Waldrop

Excellent!

You're more than welcome!