Keeping sum up from forms coming in.
I am hoping someone would be able to help . As per the diagram below I have the first 7 rows which need to be fixed as they take data from the forms being entered.
I have set up the form to enter the sheet from the bottom of the sheet, my objective is to have row 7 be a sum up of all the forms that are entered .
However the form does not come in as a child to the parent row so cannot sum up that way , I also tried just doing a straight sum up formula, however when I bring in a form it comes in under my formula.
Is there a way for me to have the forms come in and a sum up of that has come in?
Any help would be greatly appreciated.
Answers
-
Hi @penny53731
I hope you're well and safe!
Try something like this.
- Add a so-called helper column, Autonumber. In my example, I've named it Autonumber.
- Then set the number that the parent row is and sum/count all that is higher.
=SUMIF(Autonumber:Autonumber, >7, [BiFlex 10L]:[BiFlex 10L])
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!