Jonathan - profile

Jonathan · Jun 28, 2022

For example, I have a date field, some of which are filled in, some of which are not. I want to make a second date field that is a time offset from the first. I want this formula field to stay in date format so it can be exported to a calendar, etc...

Jonathan · Jun 28, 2022

Just leaving the “else” argument blank seems to work: IF({date}, something) Date format for formula not formatted correctly and cannot change format Dates and timezones Hi Laurence. The problem is that your IF statement c...

Jonathan · Jun 28, 2022

That doesn’t work, as I said. "" is a string, not a date, so the field cannot be formatted as a date anymore:

Jonathan · Jun 28, 2022

Unfortunately that doesn’t work for dates. I wonder if there is a “null date” concept that could be used for blank cells but still allow the field to be formatted as a date

Jonathan · Apr 17, 2022

Make a Button field and for URL formula, use the previous formula or something like this if you have the whole address in a text field: "https://www.google.com/maps?q="&ENCODE_URL_COMPONENT(Address)) and it will make clickable links in a field: The...

Jonathan · Feb 22, 2022

I want to know who keeps accidentally creating blank fields. Where is the history for the table as a whole?

User Statistics

User Activity

Is there a "null date"? So I don't get errors or "Your result type is not a number or a date."

Re: Is there a "null date"? So I don't get errors or "Your result type is not a number or a date."

Re: Is there a "null date"? So I don't get errors or "Your result type is not a number or a date."

Re: Your result type is not a number or a date

Re: Map from address field

Re: Base level revision history