Date Column with some cells with "only text"

[romovaro]

Hello,

I have a quick question. I have a Date column but some cells have a text format "Live". If I use "date format" in the column, all "live cells" = Error. What is the best way to format this column?

Ops Forecast & Actuals

01/06/2021

01/09/2021

01/09/2021

Live

01/11/2021

01/11/2021

01/11/2021

01/11/2021

[timg]

Hi Romovaro, 

This depends on how you would like to use the column. If you would like to use date analyses (e.g. relative date filters or continuous x-axis in line graphs) you should format the column as date and replace the "live" value with something else (e.g. a blank). If the column is purely descriptive you could format it as a text, this way both the dates and "Live" values can be maintained.

Regards,

Tim

[romovaro]

Hi timg. Yes, I wanted to use date analysis. I will replace the "live" value. Thanks

[Pragati11 · Accepted solution]

Hi @romovaro ,

Datatype of this column should be TEXT.

Thanks,

Pragati