Hello,
I have an attachment template:
But appsheet provides this error in the audit log when I try to run this report:
“Errors”: "> Error: Report ‘Timesheet’ action ‘Email Timesheets’ Attachment template.> Expression ‘[Supervisor]’ is invalid due to: Unable to find column ‘Supervisor’.> Error: Report ‘Timesheet’ action ‘Email Timesheets’ Attachment template.> Expression ‘[Project]’ is invalid due to: Unable to find column ‘Project’.
This error message continues on to the final column.
I have noticed that it does not include the first column “Employees”
I am unsure what the issue is. I originally thought it was that my select expression was incorrect but I cannot see why.
<<Start: Select(Timesheet[Timestamp],[Timestamp]>Today()-7)>>
Timesheet is the spreadsheet table
[Timestamp] is the key column in the table
If you see the issue please let me know.
Thank you
