This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
