Sign in to join the conversation:
Hello Team,
I would like to know how to enable or create smartsheet to send automated birthday emails with customised template to employees in my org, on their birthdays.
aprriciate for the help
Hi Mitta,
The simplest method would be to add their upcoming birthday and a workflow that would trigger an alert on that date yearly.
Would that work?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
You could use concatenation to create the custom messages in combination with andrees suggestion.
Column1: Contact column with list of employees names
Column2: date column with their birthdays
Column3: First part of message. something like "Happy Birthday"
Column4: Second part of message. Something like "! We at eagleview would like to wish you a happy birthday this year! Here's hoping you have a great one!'
Column5: Post out. =[Column3]@row + [Column1]@row + [Column4]@row would look something like this: Happy Birthday Mitta! We at Eagleview would like to wish you a happy birthday this year! Here's hoping you have a great one!
Of course you can mix this up anyway you want.
Hello, I have two sheets. One is "Current tasks" and one is "Completed tasks". I have the rows (individual tasks) auto number when entered (2026-001, 2026-002, etc.). When the row is marked complete, it is moved to the "Completed task" sheet. The problem I am having is that when the row is moved the other tasks that remain…
Its very frustrating when you are adding multiple columns and having to use the slide bar to move to the end and then click the 3 dots and add another column. Seems there has to be an easier more productive way.
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
