Formula for totaling a sheet cell via a form...

Hi All,

I am struggling to figure out a way, which I hope is ironically simple, to use a form for input data to modify a running total of something.

My riveting scenario is as follows:

I made this nifty form that works well on mobile for employees in the field to provide needed data easily.

My issue is taking this wonderful data from the form and massaging it on the back end to keep a tally of addition and subtraction from and to each location. I want the form to do the heavy lifting.

I hope this makes sense...

Thanks in advance to anyone that is willing to help!

John

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Johnny Jobsite

I hope you're well and safe!

Have you explored using Reports?

Would that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Johnny Jobsite

Hi @Andrée Starå

Thanks for the reply.

I never thought of a report, as I sought a formulaic solution.

After much research in learning how to construct functions in Smartsheet, I was finally able to craft a SUMIF statement that solved my query.

Thanks,

Andrée Starå

@Johnny Jobsite

Excellent!

Happy to help!

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.