Clay formula
Days since last signal
Converts a timestamp into a day count so you can sort by signal freshness.
Columns it needs
Signal Date
The snippet
IF({{Signal Date}} = "", 9999, DATEDIF({{Signal Date}}, NOW(), "days"))How to use it
- 1Sort descending on freshness, or filter to under 30 days for active plays.
datesrecencysignals