Is it possible to add the current date for an email alert?
I am trying to add the current date when sending out a weekly notification. As part of the customized message I would like to add the current date in the subject field/line. Is that possible?
Answers
-
Hi @DG at HRc
If you're using a date-based workflow, then no, there currently isn't a way to add a dynamic date into the subject line. You could potentially have a helper column that identifies the dates, and show this column as content in the alert.
I would personally add in helper text such as "Today's data" or "This Week's data - Monday to Friday" which will be static text but provide context. The email itself should have a date associated with it which should help clarify what day "today" is intended to be.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@DG at HRc As Genevieve suggested, if you have a helper, date column (like TodaysDate) you can place the column formula,
=TODAY()
, in it. Then use the placeholder, {{TodaysDate}} , in your subject line: for example, "Notification for Week of {{TodaysDate}}".
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!