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

Sumanth

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

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