Error message: Column Name 'Guest fee' in Sch...

(Ken Bell) #1

Error message: Column Name ‘Guest fee’ in Schema ‘ContractData_Schema’ has a Sheet Formula as well as an App Formula. This is not allowed. Spreadsheet formula I can’t remove: RC[-5]+RC[-4]+RC[-1]

Hi, I’m having difficulty removing a conflict with my formulas.

My original formula from my data was a formula in Google Sheets.

I’m removing that formula from my Google sheet and adding it as an app formula.

For some reason after the sync with my spreadsheet, I still see the spreadsheet formula in the auto-compute section.

This field is grayed out and it does not appear that I can manually remove it, as I have done many times in the past prior to today.

Is this a bug related to today’s earlier problem with Google Sheets? Any help would be appreciated.

(Aleksi Alkio) #2

Hi Ken, is this still an issue or have you found out what was the reason?

(Ken Bell) #3

@Aleksi_Alkio thanks for your reply.

Yes this problem persists.

I would simply like to have the ability to change spreadsheet formula to a value and then create the same formula in Appsheet.

It does not appear to be possible.

Thanks

(Aleksi Alkio) #4

We will update this feature with the new editor.

(Aleksi Alkio) #5

If you want I can check your app. For doing that, I would need to know the account ID, app name and then table/column name.

(Aleksi Alkio) #6

One thing you can do… copy & paste your values in that column as “Paste values only” and then regenerate the column structure. Then it won’t read any sheet formulas and you are able to add an app formula.

(Ken Bell) #7

Thanks I did exactly that.

There seems to be a bug.

Despite having only values in that column in Google sheets, AppSheet still recognizes the old formula after I regenerate.

I would guess there is an issue with the regeneration.

(Aleksi Alkio) #8

Let me check this…

(Aleksi Alkio) #9

It seems that you are correct. It won’t do that. As a workaround you can change to old editor and remove that formula because that field is editable.

(Ken Bell) #10

Thanks.

Yes I would like to revert to a previous version of the editor.

How would i do this?

(Aleksi Alkio) #11

In your URL after the app name & account ID add &OldEditor=true… like …AppName-000000&OldEditor=true&…

(Ken Bell) #12

Thanks so much.

I don’t know the reason for the change in the latest version, but my vote is for the prior version’s ability to delete the spreadsheet formula.