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.
Answers

Consider using a
SUM
function in a Summary F\field. You can see an example of that depicated here: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/2476786defineyourworkwithsheetsummary

Mary,
You're going to have to dumb it down a little bit for me. What would the formula look like?
Help Article Resources
Categories
Check out the Formula Handbook template!