Unwanted Space appearing in expression causing app to crash

[Rich_Barber]

The app would not run and told users to contact the developer,.
Extensive troubleshooting found a space had been added to similar expressions for 6 virtual columns. Here is the error:
Column Name ‘PTO Used’ in Schema ‘Employees_Schema’ of Column Type ‘Decimal’ has an invalid app formula ‘=SUM(SELECT( TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[ EmployeeID],[Task]=“PTO” ) ))’. Error in expression ‘[_THISROW-1].[EmployeeID].[ EmployeeID]’ : Unable to find column ’ EmployeeID’

Looking at Copy26Sep2020 test version of TT Admin, it is running without errors.

PTO Used (Decimal)

SUM(SELECT(TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[EmployeeID],[Task]=“PTO” ) ))

Prod is

SUM(SELECT( TimeReports[Hours_Worked],AND([EmployeeID] = [_THISROW].[ EmployeeID],[Task]=“PTO” ) ))

Note there is a space infront of the E. This is the case in all 6 virtual columns. I fixed all of these and we are good!!

[Steve]

What are you looking for from the community?

[Rich_Barber]

This appears to be a bug. How did the spaces get added?

[Steve]

Good question. You should probably engage support@appsheet.com for help with this.

[Rich_Barber]

Thanks Steve. I submitted to support.appsheet.com today,