Multiple value type appsheet

[Prasert]

Hi I'm devleoping an app in Appsheet and found one problem that would like to get help. There is a column that normally the value is date then I select type of data as date. By the way, there are an condition that I would like to put "N/A" as a value on the date. How can I do that?

[TeeSee1]

I do not think you can. So either use a blank or a date that you would never use as a valid date (Ex. Jan 01, 1800) as a substitute for NA.

[Prasert]

Thanks, then it only by put "" as blank

[TeeSee1 · Accepted solution]

Yes, a "" (two quotes with nothing in between) should do it.