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
Clay Cup

Powered by Tightknit

Creating a Formula Field to Check for This Week's Date | Clay

Creating a Formula Field to Check for This Week's Date

·May 29, 2025 10:33 PM·

Hey Team - I have a Formula Field I am trying to create where the formula should be: Check if a specific field has a date from this week, and if it does, return true. The formula is giving the entirely wrong output though when using the AI prompt for it. What is the best way to make this work?

3 comments

· Sorted by Oldest

Channeled
APP
·
·
To create a formula that checks if a date is from this week: 1. Add a new column and select Formula 2. In the AI Formula Generator, type something like: "Check if /[your date field] is from the current week and return true if it is" 3. Click Generate Formula 4. Review the sample output to verify it works correctly 5. Click Save Formula If the AI doesn't generate the correct formula initially, try adjusting your prompt wording or directly modify the generated code. The preview feature helps ensure you're getting the right results before applying.
Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University Formulas Formula generator | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.
Nicole L.
·
·
Thanks! It was an error on my Account List from SF causing the trouble. All set here.