Need the count of matching dates on a list of dates

I have a list of dates on a thing. I’m trying to create a formula that calculates the number of dates that match the single date value in a date picker. Then I want to compare that value > to antoer number on a user record. Looking for the yes/no to move forward in a workflow. This is probably an easy one but I cant seem to make it happen.

Thanks!
Dean

[your thing]'s [list of dates field]:filtered, then add a new constraint This date:formatted as 2/14/23 is [your date dropdown]'s value:formatted as 2/14/23 then close out of the filter window and do :count

After that you can do > [your user record]'s [number field]

This would return a yes/no depending on if the count of dates > than some User’s number field.

1 Like

THANK YOU for saving me countless hours!

1 Like

This topic was automatically closed after 69 days. New replies are no longer allowed.