having the ability to type the expression inside of your spreadsheet with some sort of trigger that lets app sheet know that the text string that follows is to be used as an app formula to be applied to the column. it would greatly reduce the time it...

I was wondering if it is possible to use math expressions on ref_row to duplicate the effect query has in google sheets.example of google sheets formula =query({B1:E},"Select Col1,sum(Col2),sum(Col3),sum(Col4) where Col1 matches '"&textjoin("|",1,A1:...

Im going to start by explaining the main points of whole project im working on.The purpose of the APP is record keeping for a gaming community i belong to that is based on hockey.Previously record keeping was done all by pictures and manually enterin...

    I have a table with multiple UX Format rules that the yes/no condition is not working anything near its intent.I have a Column name "POSITION" that contains one of these "C,LW,RW,LD,RD,G".Im using the formula CONTAINS([POSITION],"(One of the text...