I’m trying to create a slice that filters a DUEDATE (date) minus than today but having also some data with no DUEDATE i don’t want to show this kind of empty data
How to do it ?
I’ve tryed with this formula but don’t works:
AND(
([DUEDATE] < TODAY()),
([DUEDATE] ISNOTBLANK = TRUE )
)
I think Date fields automatically get an initial value of now(). Could it be that your dates all have values? If so, remove the initial value and see what you get when expecting a blank value before adjusting your formula. I suspect that even without the initial value, the field will fill with zeros. Is so, you could use something like left([DueDate],4) = “0000” or whatever matches the “blank” date in your AND statement.
in my Google Sheet the column (DATA field) has no data in it, totally blank, i’ve double check it now
in my AppSheet when add e new record is shown
gg/mm/aaaa
I’ve also tried to filter undue tasks with date in it (minus than today) but no data are shown too:
AND(
([DUEDATE] < TODAY()),
([DUEDATE] ISBLANK = FALSE )
)
And i see that my initial value of DUEDATE column is blank too
I dunno what your problem is, I’m sorry to say. I just tried a bunch of things and I cannot replicate your problem. The isblank() approach worked fine for me.
Could be something related to my setup that is in Italian language ?
I’ve setup in my Google Sheet the column the date (please see pic)
And when add a new record it’s shown in AppSheet (please see pic).
Seems ok here, isn’t it ?
And one more: the code goes in Slices or in UX showif ?
Actually i’ve inserted in Slices
Yes, that looks fine. I doubt it has anything to do with your language choice.
CIAO!
Solved with this formula:
AND
([DUEDATE] < TODAY(),
ISNOTBLANK(DUEDATE])
)
