Date Comparison Not Working... Help

My backend is a Google sheet.  My Date column is validated as Date.   Appsheet automatically define the column as type Date.  

My problem is when I only want to show all rows greater when the Date column is greater than today(), if still shows all rows.

Here is what I did.

In the column named Date and the type is Date, I went to the column's Data Validation 

Valid If the formula for column Date (Yes/No,List)

[Date]>=TODAY()

I resync several times yet I still get all rows.  Can anyone assist?

0 1 84
1 REPLY 1

It sounds you are trying to filter data depending on the date. For that purpose you need to create a slice with your formula. Valid_If is only meant for validation when the user fills or updates the row.

Top Labels in this Space