When I create a column and type in a number that automatically converts the column to date type, and then I revert it to text type again, it is shown as data value when used in a formula.
Interesting 
…
I think this is, in a way, somewhat related to this bug (tracked on Coda’s side 
) :
1 Like