Using a Sheets form for film ratings, how can I auto-calculate an average from four ratings and insert it into the corresponding row upon submission?
hey, try using a google script triggered on form submit. once a new row is added, compute the avrage from the required cells and update the row. i tried it for my project, works well.