Has anyone created a “Today’s Date” column you can automate off of? Is there a good app for this? Make.com or zapier are the only options I am aware of.
Thanks,
Charlie
2 Likes
You could create two date columns: Today and Tomorrow and have a following automation:
Every day it will update Today column to today.
4 Likes
Hi! Maybe a formula column with the today function works for you?
You can format it anyway you like,
Hope it helps!
Keep in touch,
I have this done on one of my boards. It uses a lot of automation credits because it runs for every item so I suggest scoping the update to only run on items that need to have the “Today’s Date” value current. For example, I don’t update any items marked as “complete”.
Great solutions here! Just wanted to add a cost-saving tip for the automation approach:
Instead of updating every single item daily (which burns through automation credits fast), you can scope the automation to only update items where it actually matters.
For example:
- Only update items with status “In Progress” or “Active”
- Skip items marked “Complete” or “Done”
- Or add a checkbox column like “Needs Current Date” and only update those
This way you’re not wasting credits updating the date on hundreds of completed items that don’t need it. The formula column approach Jose showed is also solid since it doesn’t use any automation credits at all - just calculates the date automatically.
Both methods work, just depends on whether you need the date to be stored as actual data (automation) or if a calculated display is enough (formula).
1 Like
@Charlie_F - what’s your use case?
Hey @Charlie_F
Have you tried the Subitem Automations app yet? Might be a good fit for your case.
If you could describe the use case a bit further, we can give you a more appropriate solution.