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.
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!
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!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
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?
Hmmm. What are the formulas you're using? Can you share them so we can see how they're constructed?
Will the screenshot below give you what you need? Basically the same formula in all of summary fields.
Referencing the column seems to have worked. Thank you both for your time and insight!
You're more than welcome!