Date Comparison Not Working... Help

AppSheet AppSheet Q&A
1

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?

2

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.