.png){kind=logo}
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?
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?
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.
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
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.
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.
How do I set up each row in a Clay table to auto-update so the "current date" column refreshes?
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.
Does setting a table on a schedule cost credits if it is only updating the date each day?
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.