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?
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.
User | Count |
---|---|
43 | |
27 | |
23 | |
14 | |
12 |