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

·

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

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 02 Support.
Nicole L.
·
·
Thanks! It was an error on my Account List from SF causing the trouble. All set here.