With the new UI, I canโt figure out how to enter a โSpreadsheet formulaโ in the Auto Compute section.
My existing ones were ported over, but the field seems to be missing?
Please advise. Thanks!
Adding @praveen to investigate.
Hi @Phil_Robertson this is by design. Spreadsheet formulas are defined in the spreadsheet, not via the app editor. APpSheet will pick them up when you add a table or regenerate a column structure.
So if there is a spreadsheet formula, the app editor shows it. In fact, it should not be editable, but there are some cases where we extract the spreadsheet formula wrong and it needs to be manually corrected.
Hope this explains
@praveen Thereโs a piece of the puzzle missing for me here.
AppSheet will add a new row to the spreadsheet with each new record, so if I want it to pick-up a formula where do I locate it in the spreadsheet?
I just attempted to put a formula in the previous row (i.e. most recently created record) and then do a regeneration of the table structure but I donโt see a formula populated in the AUTO COMPUTE section. Conceptually, locating formulas in the sheet still doesnโt make sense to me because itโs creating a dependency between previous records and new records.
Unless Iโm missing something?
EDIT: I copied the formula to all existing rows in the column.
I then regenerated the table structure.
I still donโt see formula in the AUTO COMPUTE section of the table columns.
Please advise how I do this?
If the formula is in all the rows and you regenerate, you should see the formula picked up automatically. Check your Info pane for warnings. Most likely, the formula is not one that AppSheet will accept because it uses positions.
From AppSheetโs point of view, a columnโs value can be assigned in one of three ways:
a) it is added and edited by the app end user
b) if it automatically computed by an App Formula (Virtual columns are one instance of this)
c) it is in the data tier (i.e in Google Sheets or Excel or SQL etc) or it is computed by AppSheet.
In case ยฉ, AppSheet will just treat this as a read-only column. However, when inserting a new row, it needs to know what formula to put back into it, so thatโs why it detects and extracts the spreadsheet formula. AppSheet makes no guarantees of the row position where a new row is going to be added. Therefore, any spreadsheet formula that is based on position will be ignored.
Hello,
I have the same problem with the, AppSheet does not generate the formula of my spreadsheet.
I already reviewed everything you comment and apparently I have everything fine, I can not find the cause.
Could you guide me what else to review โฆ
Thanks
Please contact support@appsheet.com for help with this.
thanks
@praveen I did have a warning on the info paneโinconsistent formula, seems I missed a row!
Itโs working now, thanks!
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |