Display date and duration by referencing other cells in the same sheet

Hello Everyone,

I'm trying to reference data from row 44 into row 3 in the same sheet. "=[Task Name]44" works like a charm (see below). However, =[Start]44 doesn't result in the date "08/13/25" being reflected in row 3. Likewise, =[Finish]@44 doesn't reflect the Finish date from row 44.

=[Duration]@44 or =Duration44 doesn't work, either. The reference works for text but not for numbers in my case.

How do I correct this? Appreciate any tip or support.

Best wishes,
Sumanth

Find more posts tagged with

Cell linking

References

dates

Accepted answers

All comments

Joseph Aloysias - vSaaS Global

Hi Sumanth,

Formulas won't work in columns configured under Project Settings. To use formulas, we need to disable Project Settings first. Please refer the below article for disable project setting,

https://help.smartsheet.com/articles/765755-modifying-project-settings

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.