Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Check In/Out inventory log

✭✭
edited 12/09/19 in Formulas and Functions

Hello, 

I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number remaining in the inventory. 

For instance, I pack 10 pens for an event and only 4 pens come back, I need a way to track that there are 6 fewer pens in my inventory. I'm sure I can figure out the formulas if I do the subtraction myself and enter the negative number but I was really hoping to save myself this couple of steps since we do quite a few events throughout the year.

Anybody know if this can this be done or is this wishful thinking?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

  • I am trying to create a formula that looks at 2 different columns Term Ending Date and Amendment - Ending Date. If column Amendment Date does NOT contain N/A it should return the value in [Amendment -…
    User: "n7teixeira"
    Answered ✓
    13
    2
  • Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up …
    User: "JordivL"
    Answered ✓
    21
    1
  • Hello, I've formula use Workday to count Due date = Start Date @row cell + option days. fx Image below: Start Date is 04/24/25, then added 11 days = Resulted 05/09/25 as Due date. Now, out of curiosit…
    User: "JinwonK"
    Answered ✓
    49
    4