I want to schedule a monthly report that makes a sum of a specific column at the end of each month for that last month. (i.e. On the 5th of month “m”, I would receive a report from the 1st day to the last day of month “m-1”). I tried the following condition: MONTH([Date])=Month(Today()-1). However, AppSheet gives me the following error: Unable to find column ‘Date’. Now I’ve double and triple checked, the column DOES exist (both in AppSheet and in Google Sheets) AND I’ve listed the correct table name for the report. So what am I doing wrong? Or is it a bug from AppSheet? Thanks for your help!
LinkedIn
Twitter
