Filter slice by date range from another table

AppSheet AppSheet Q&A
1

Hello.

I am trying to display data in a slice with dates by filtering from another table.

I have a timesheets table with date entry rows and trying to filter from a payroll date range in another table. Both columns are set to date type but I am getting the error:

CRS_R_Newell_0-1645592278805.png
CRS_R_Newell_0-1645592278805.png820×111 6.85 KB

Not sure why it thinks its a ‘List’ as its set to date. This expression works when i simply do a date expression filter like > ()TODAY

Thanks

2

Payroll Date Range[Start Date] gives a list of date values in the entire [Start Date] col.

So you have to limit it to one value.

If the table has only one row, user ANY(Payroll Date Range[Start Date]).

If not, you have to have a constraint condition added.

2 Likes