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 "rate" field that comes in in different formats so airtable (and excel) treat it as long text.In excel I convert it to a number with this formula: =IFERROR(VALUE(IF(ISNUMBER([@Rate]),[@Rate],LEFT([@Rate],FIND("$",[@Rate])+4))),"")Because th...
