I have a field which look at a date field and depending if it exists will write "Scheduled on {Scheduled} The formula is IF({Scheduled}>TODAY(),"Scheduled on "&{Scheduled}, “Not scheduled”), But it writes the info as “Scheduled on 2020-03014T00:00:00...

I have a sheet where interaction type field is a Single Select list Date of Interaction field is a date The following formula returns a date in the format 2019-11-05T00:00:00.000Z IF({Interaction Type} = “Meeting”,{Date of Interaction}," ") How can ...