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.

email.png

smartsheet.png

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Can you provide a screenshot of the formula(s) used as well as the automation?

Dan Tanner

Hey Paul,

=ROUNDDOWN((TODAY() - [Last Hire Date]@row) / 365, 0)

(Edited the [ column ] for privacy, but formula works...).

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.