Moving column in Google Sheets causes error

Iโ€™ve moved a column in a table called sync, then did a Regen Columns. Then got this error on all tables with a โ€œAre updates allowedโ€ formula:

Table โ€˜Customerโ€™ has an invalid update mode expression โ€˜=IF(IN(โ€œAdminโ€,ANY(Select(Staff[Type],[Login Email]=UserEmail()))),โ€œALL_CHANGESโ€, IF(IN(โ€œManagerโ€,ANY(Select(Staff[Type],[Login Email]=UserEmail()))),โ€œALL_CHANGESโ€, โ€œRead Onlyโ€))โ€™. Unable to find table โ€˜Staffโ€™, did you mean โ€˜Staffโ€™?

After much faffing, simply getting the app to so a save & verify sorts it. But it seems this is a bug that has crept in someswhere.

0 2 150
2 REPLIES 2

Steve
Platinum 4
Platinum 4

I get this occasionally. A hard reload of the app editor (Shift+Ctrl+R) typically helps. Did you try that?

No

Top Labels in this Space