Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Discuss Anything

Ways to Count Days Since Record Creation in Automation Systems | Clay

Discuss Anything

Ways to Count Days Since Record Creation in Automation Systems

·

·

Hey guys, curious how i can implement this. I want to count days since a record was created, but when i use a formula it doesn't update automatically. What other methods has anyone found to make that work?

6 comments

· Sorted by Oldest

Abdul S.
·
·
Hey Jake G. yep, formulas don’t auto-refresh in clay just set a daily automation to re-run the table so the “days since created” updates automatically
Jake G.
·
·
Im confused what you mean? Like just a random automation that will trigger the formula?
Abdul S.
·
·
Yeah exactly just a daily automation that re-runs the table that refresh alone makes the formula recalc automatically
Jake G.
·
·
So i have that already. TLDR is i have a mixpanel integration tracking for activated users. That runs daily. But that hasn't been updating the formula.
Jake G.
·
·
Now i can place the formula as a run condition on a send to campaign column. Which will rerun daily. Not sure if that's a good fix.
Abdul S.
·
·
That could work if the run condition actually triggers the row to update clay only recalcs when something in the record changes so as long as that “send to campaign” field updates daily, your formula will stay current
1