How to select Column

Mark12345 · 05-23-2020 08:05 AM

Hi all,I would like to ask the above question as shown in the image
(1) Is it possible for appsheet to do this?If so,what alterations should I make? (I do not want to change the columns below as the form for users to input is simple and efficient)
(2) If it is not possible,should I split each item into 3 virtual columns,each calculating their own values?
(3) Or should I change something fundamentally?I might be barking up the wrong tree =(

I hope I have maid myself clear.Also,pardon me if I reply “Late”,I am from a gmt+8 country

Thanks in advance! 😃

Steve

SELECT() can only return values from a single column. If you want to sum values from multiple columns from a different row or across multiple rows, you’ll need SELECT() expressions for each column.