Dataset formula to count empty dates

Hi all,

I am using datasets and formulas and trying to figure out how to calculate the number of empty dates in a specific custom field. Is there a formula that checks whether a date field is empty and returns a true/false?

Hi @SimonP1,

The datasets currently only support row-level calculation → cf. this article and a reply from November 2021.

If I understand correctly, let’s say you have a purchase_date property, you want a formula that returns the number of empty purchase_date among all the rows in your dataset ?

If I understood correctly, you’d need an aggregate function to run a function over several rows and count if null or empty, so I’m afraid for now you won’t be able to make that work.
Hope this helps ! If it does, please consider marking this as a solution :slightly_smiling_face:

Have a good day,

Ludwig