Linking a cell (date) to another sheet and adding extra days to in Smartsheet

Hello Community,

I need to link a cell to another cell (different sheet) and also add extra number of days to the value in the cell. What is the best way to go about this.

The cells are dates, for example

Sheet 1 has cell A = 12/05/23 needs this cell needs to be imported to Sheet 2 cell B plus 10 days.

Find more posts tagged with

Accepted answers

Paul Newcome

In that case you would need to create the cell link in one column and then add then days with a cell reference to the linked cell in another column.

All comments

Paul Newcome

Is there a unique identifier on the row in both sheets we can use to match them together, or are you wanting to just pull in a direct cell link?

Naska87

There is no identifier, I just want to pull the cell link and add extra number days to it in the other cell in a different sheet.

Paul Newcome

In that case you would need to create the cell link in one column and then add then days with a cell reference to the linked cell in another column.

Naska87

Thanks, I thought about that too but was wondering if there is a better way to get it done. Thanks Paul much appreciated.

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.