Hi there,
I just imported a spreadsheet that currently has a column that would be a “multiple select” in airtable, each entry separated by a semicolon.
For example, here’s how a few cells in the column might look:
Alabama; Michigan; Massachusetts
New...
I got around this by adding a formula column called Has Due Date (which I then hid) that is 1 if it does and 0 if it doesn’t. (Test if {Due Date} = BLANK()) I sort by that computed column first and THEN sort by the Due Date field. It’s a bit of a hac...
The problem with that is airtable doesn’t have a find-and-replace yet and I can’t import the data with commas in it because airtable only accepts .csv and not .tsv. So… I’m trying to find another solution besides changing literally thousands of semic...
