Clay Icon

Dynamic Cell for Auto-Updating Current Date in Spreadsheets

·
·

Is there a way to have a cell in a row always show the current date? Essentially a dynamic date field that updates automatically each day?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can create a dynamic date field that updates automatically each day. There are two ways to do this: 1. Use a formula: Write moment().format("MMMM, D YYYY") directly in the cell. This will display the current date and update daily. 2. Reference the "Created At" column: Every row in Clay has a "Created At" column. You can reference this to show the current date. Both methods will give you a dynamic date field that updates automatically each day.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback ​Malik​!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

  • Avatar of Malik
    Malik
    ·
    ·

    Using moment().format("MMMM, D YYYY") in a cell does insert the current date and time, but if I go look at that same cell the following day, it still shows the old date, it's not updating automatically every day.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    The formula "moment().format('MMMM, D YYYY')" doesn't update automatically each day because formulas in Clay are calculated when the row is created or updated, not on a daily basis. To create a truly dynamic date field that updates daily, you can use the "Format Date/Time" action in Clay workflows. Here's how: 1. Add a new column and select "Format Date/Time" action. 2. Use the current date as input (you can reference the "Created At" column). 3. Choose the desired output format (e.g., "MMMM, D YYYY"). 4. Set up auto-update to refresh the column daily. This approach will ensure your date field updates automatically each day.

  • Avatar of Malik
    Malik
    ·
    ·

    How do I set up each row in a Clay table to auto-update so the "current date" column refreshes?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To set up your "current date" column to auto-update daily, you have a couple of options: 1. Use a formula: Create a column with the formula moment().format("MMMM, D YYYY"). This will dynamically populate the current day's date without needing to update. 2. Use scheduled columns: • Click the ⛭ icon on the top right of your table • Under "Run the table", select "On a schedule" • Choose "Day" as the frequency • Select "Only selected columns" and choose your date column Additionally, you can enable auto-update for your table, which will automatically run all columns when rows are added or edited. These methods will ensure your "current date" column stays up-to-date daily.

  • Avatar of Malik
    Malik
    ·
    ·

    Does setting a table on a schedule cost credits if it is only updating the date each day?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Setting a table on a schedule in Clay doesn't directly cost credits. Credits are used for data enrichment actions, not for scheduling itself. However, if your scheduled table runs include enrichment actions, those will use credits when they execute. To manage credit usage, you can use features like turning off auto-update for columns or entire tables when you're not ready to enrich new entries. If you need more specific information about your table's credit usage, you can view the credit cost for each action in the enrichment panel.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·