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 · Sep 15, 2023

@Greg_F From the article:“We are realigning to go after bigger use cases, and therefore bigger deals. We want to consistently get customers with million-dollar-plus spend rates, versus supporting lots of little ten-thousand-dollar customers from a sa...

Jonathan · Aug 25, 2023

@Robert_William1> Is there an extension for moving all my clients from Airtable to Google Sheets, Smartsheets, or Glide? Those would be very clunky replacements for Airtable. There are much better choices now, which are specifically designed to be A...

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

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: Updates to Our Pricing Plans

Re: Updates to Our Pricing Plans

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