Issue when values from form are not added into the sheet

fb_smd

I am trying to create a form that records the number of people that walk into a store, if they purchase a product then we will add it as revenue. When I am trying to complete the form for the employees, the formula that I have for sum the values it's not working for those that are added.

Paul Newcome

What is the formula you are currently using?

fb_smd

Hi @Paul Newcome, I was able to populate it. I used a formula that applies to all the column on a different column. I am not sure how, but now when I add a new value the values follow and any change I make, the conditional formulas I applied helps categorizing the changes.