New to Smartsheet add number to date in new column.

I have an Approval Date column, and an Approval Cycle column. The approval cycle column is a dropdown of varied numbers. The third column should take the date from Approval Date and add the Approval Cycle number to the year. This is what is in there...

=[Approval Date]@row + [Approval Cycle]@row

But it's just adding it as an extension of the date number, so it's showing as 02/14/202412 rather than adding the 12 to the year. I'm a little perplexed on the formatting and fully admit my neophyte status on the formatting. Any help would be appreciated.

***

Update, I was playing with it and now it's adding it to the day rather than tagging it at the end of the year. Some progress, but I still appear to be missing something.

=[Approval Date]@row + [Approval Cycle]@row

Thanks!

Find more posts tagged with

Accepted answers

All comments

John_Foster

Hi @Kaibutsu,

I would use the following formula, which extracts the sections of the date from your date field and then puts them back together.

=DATE(YEAR([Approval Date]@row) + [Approval Cycle]@row, MONTH([Approval Date]@row), DAY([Approval Date]@row))

Hope this helps!

John

Kaibutsu

Entirely my fault for not putting something else in here. That formula worked perfectly, so thank you for that. The Approval Cycle column is supposed to be in months, so, say the next approval date is six months from now, or 1 to 2 years from the date. It's adding the Approval Cycle to the year, so that's perfect, but I am unsure how to make the formula understand that the column is months rather than years. Thank you again for the help. I really appreciate it.

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.