Login Page - Create Account

Support Board


Date/Time: Sat, 03 Oct 2026 17:56:36 +0000



Post From: Text Display from Study

[2026-09-16 13:36:31]
Sawtooth - Posts: 4355
I’m trying to display that date on the chart using Text Display for Study from Spreadsheet
The Text Display from Spreadsheet study will only display text from rows 1 and 2.
So the value in L3 needs to be converted to text.

Try this in cell L2:
=CONCATENATE(YEAR(L3),"-",MONTH(L3),"-",DAY(L3))

Then in the Text Display from Spreadsheet study, set the Cell Reference to L2.