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?
-
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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!