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 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 ![]()
Have a good day,
Ludwig