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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!