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 EXPERT CONSULTANT & PARTNER
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 for help with Smartsheet, integrations, general workflow advice, or anything else.
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!
Right now we have the Business Plan, but I'm considering moving to the Enterprise Plan only to get access to the Work Apps feature. Looking for some real user reviews to determine if it would be worth it. What do you like and not like about the feature?
I am looking for a way to set up a report in my parent blueprint so that: Every time a new child project is provisioned, a specific sheet from that project is added to the report at the parent level. The parent report is a collection of that sheet in all child projects. Things I tried that didn't work: -Adding the child…
How do you get the URL for the Calendar so that others can view. I tried the Open Sheet, but cannot find the "Web Form" anywhere.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.