Clay Icon

Not sure why this formula isn't working.

·
·

Not sure why this formula isn't working.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To troubleshoot formula errors in Clay, try these steps: 1. Review your formula syntax: • Ensure you're using "/" to reference columns correctly • Check for any typos or missing characters 2. Use the AI Formula Generator: • Add a new column and select "Formula" • Type your desired action in the AI Formula Generator box • Click "Generate Formula" and review the sample output 3. Iterate and adjust: • The AI might not give perfect results on the first try • Modify your prompt or tweak the generated code • Use the preview feature to check results before applying 4. Clear cache and refresh: • If you're seeing unexpected results, try clearing your browser cache and refreshing the page If you're still having issues after trying these steps, request human assistance by clicking on "Talk to a person" for more detailed help.

  • Avatar of Justin T.
    Justin T.
    ·
    ·

    no

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Hey Justin, thanks for reaching out! Just to confirm you're trying to reformat this into "YYYY-MM-DD" right? If so, what is preventing this from happening is that column type. Right now the column is set to "date" format which by default formats it into the Month DD, YYYY format. To get rid of that and have custom formatting you can revert the column type back into a text column as shown in the video below. :) Let me know if this helps!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Justin T.
    Justin T.
    ·
    ·

    doH!

  • Avatar of Justin T.
    Justin T.
    ·
    ·

    ofc!

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Let me know if there's anything else we can do to help! :)