Clay Icon

How to Use Today's Date Dynamically in Spreadsheet Formulas

·
·

When using today's date in a formula, how can I get it to update based on the actual date. E.g. I have a column which is today's date, but I want it to show today's actual date based on when I open the sheet, not when I created the formula / the conditions were met for the formula to output. Is there a way to do that?

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Hey Henry, thanks for reaching out! Currently, it's not possible to have today’s date auto-update without any intervention. The closest workaround would be a formula like this: {{Company Domain}} ? new Date(new Date().toLocaleString("en-US", { timeZone: "America/New_York" })).toLocaleDateString("en-US") : "" This formula will populate today’s date as long as {{Company Domain}} is present. However, it remains a formula column, meaning the date won’t auto-update after creation.

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Scheduled runs, or enrichments that be set to re-run on a cadence is on our roadmap and something we, and lots of customers are getting very excited about. Hope this clears things up, let me know if you have any other questions :)

  • Avatar of Channeled
    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.