I am a new user learning how to use AppSheet. I have created a Google Form with 6 questions which are linked to a Google Sheet and works perfectly fine. The data transfers perfectly into APP Sheet. I want to introduce a calculated variable based on values of other variables collected by Google Form and transferred into a Google Sheet. in other words a calculated column in the Google sheet which would then be transferred to AppSheet.
However, when I manually add a new calculated column in the Google sheet based on three of the variable values in sheet columns derived from the Google form I run into problems. A new user filling in the Google form only results in those values being transferred to the Google sheet, the calculation column (IFS statement) for that row is cleared, hence no calculation. Is there some way for Google Sheet calculation columns to do their job when new form data is transferred from a Google form to a Google sheet? If I manually paste the IFS statement into the row of calculated column, the statement works OK. I would like this automatically calculated as new form data rows are added to the Google sheet. If that can be achieved then the calculated variable will flow into AppSheet. Can anyone advise how I achieve this?