Automate A Cell Value

Is it possible to run a formula for a cell when a row is added?


I have our sales reps using a form to enter their customer visit details. I would like to run automation in a cell called "Obsolete Inventory" that pulls a dollar amount from another sheet when a row is added. I am trying to stay away from a column formula for this task if possible.

Thanks for any advice.


  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭

    If the formula in your cell is the entire column range then it will automatically include the amount from the new row in the other sheet. Your formula should be like,

    =SUM({Another Sheet Entire Amount Column Range})

    where {Another Sheet Entire Amount Column Range} is basically the entire column range like [Amount]:[Amount]

  • RayF
    RayF ✭✭✭

    Thanks for your response.

    I was trying to stay away from a column formula because the other sheet that I am pulling the obsolescence data from changes and is updated monthly. I want to preserve the previous entries in my main sheet and not have them updated. Could I do a VLOOKUP or Match with month criteria that would look at the Date of Contact Month and bring back data for the same month from the other sheet?

    Main Sheet

    Other Sheet