Formula help

Hello. I'm trying to compute a total running tally of "Quantity Used" in my inventory sheet with a simple formula of: =([Starting Board #]@row - [Ending Board #]@row) + 1

As a column formula placed in the "Quantity Used" column, for some reason it's placing the value of "1" in the column cells outside of the formula parameters.....meaning, when I add a number value of boards in the "Unit QTY" column (not related to the cells the formula is referencing), it populates a value (screenshot for reference).

I don't want to see any values in the "Quantity Used" column unless the range of boards used are entered in the "Starting Board #" and "Ending Board #" cells.

How do I keep the formula from computing until those parameters are met? In addition, I don't want the "Starting Board #" added to the quantity either, as this creates a skew.

I've tried everything I can think of, someone please help me! Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

Mary_A

Consider using a SUM function in a Summary F\field. You can see an example of that depicated here:

https://help.smartsheet.com/articles/2479976-calculate-key-project-metrics-with-sheet-summary-formulas

The downside is that the cell would not appear in the sheet but in the Summary Pane. You can still reference the result tho in any dashboard you want.

https://help.smartsheet.com/articles/2476786-define-your-work-with-sheet-summary

JLogan

Mary,

You're going to have to dumb it down a little bit for me. What would the formula look like?

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.