Info in email alert not same as on smartsheet
Good morning,
I created a Smartsheet for employee anniversaries. The formulas and automations are all working perfectly, there's just one strange thing that is happening.
In my Smartsheet, I have a formula to calculate the anniversary number which works great, however, the anniversary number doesn't always translate to the alert. When I get this alert at 8am, I immediately check the spreadsheet and the anniversary number is correct.
The only thing I can come up with is that the formula doesn't work until I open the Smartsheet, but that doesn't seem right...
I've attached a screen shot of the email and a screen shot of the relevant info of the Smartsheet. Please advise any ideas.
Answers
-
Can you provide a screenshot of the formula(s) used as well as the automation?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hey Paul,
=ROUNDDOWN((TODAY() - [Last Hire Date]@row) / 365, 0)
(Edited the [ column ] for privacy, but formula works...).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!