Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Dates Don't Act As Dates if Linked from Another Smartsheet

D Domine
D Domine ✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

In short... if I pull a date from another sheet using "Link from Cell in Another Sheet", I can't do formulas off that date.  I've verfied that the columns are formatted as dates.  

 

[Opening Date]1 is linked from another Smartsheet.
I want to add 180 days to the [Opening Date]1.  

[Opening Date]1 = 08/22/82

Here's what the formula looks like:  =[Opening Date]1 + 180

Here's the result:  08/22/82180

 

If [Opening Date]1 is not linked, the formula results just fine.  

 

Anything I'm missing?

Comments

This discussion has been closed.