Friday, June 21, 2013

yogi_Compute Row By Row Score For Individual Performance Based on Specified Criterion

                                          Google Spreadsheet   Post  #1256
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jun 21, 2013
user aidacuk (!category-topic/docs/spreadsheets/wJshkU062jg)
Formula Issue With Form Submissions

I have posted this in the form section however have had no luck.

I've created a form to establish Yes or No answers based on an agents performance.  For every No received this removes a percentage from 100%.  Using the formula is fine however every time a new response is submitted the formula I have put in jumps down another row.

I have seen many people suggest ArrayFormula but that hasn't worked.  Maybe I'm doing it wrong?

The formula I have entered is:


I have also deleted all empty rows, but still this doesn't copy the formula down when a new response is received.

Hi Yogi,

This is the spreadsheet: