Hi there, Im working with an app that I started from gsheetsm I already had one spreadsheet with data and a specific formula IF(RC[-10]>0,(R[-1]C-RC[-3]+RC[-2])," ") when I add two more tables like the first one the spreadsheet formula didnt come with the autocompute options, so I want to redo this ss formula but using appsheet but it seems no that easy that gsheets.
Hi,
That formula is from the spreadsheet and does not transfer into AppSheet. That formula also does not help us here because we can’t see the sheet. For example RC[-10] points to the cell -10 columns over from where this formula is. I do not know what that column is in your app. I would suggest watching some of the AppSheet Youtube videos on adding formulas.
1 Like
Thanks, I already solve it using row_column, index and ifs expressions.