Reference is changing data type from DATE to TEXT

Todd Jardine
Todd Jardine ✭✭✭
edited 12/09/19 in Smartsheet Basics

I having a an issue here and wondering if someone can help.

In the screenshot, shown, ROW 2 is giving an error when I attempt to calculate the variance between Fiscal QTR End Date and Opening date

ROW 3 is not giving an error.


Here are the differences in the rows.

Row 2 - Both Date fields with referenced from other date columns

Row 3 - Dates were manually entered.

Question: Does Smartsheet chance the data type when referencing from another date field?


Screen Shot 2019-05-02 at 4.31.13 PM.png