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.
Accept
Reject
Preferences
Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

K_B1
4 - Data Explorer
4 - Data Explorer
since ‎Apr 05, 2020
‎Jul 25, 2024

User Statistics

  • 7 Posts
  • 0 Solutions
  • 1 Kudos given
  • 0 Kudos received

User Activity

Formula, If / Or Help

Jul 24, 2024
I am trying to generate a formula where:1. If date in field x is greater than 1953, then 1 is put in field zOR2. If checkbox is checked in field y, then 1 is put in field zI came up with this formulaIF(OR({NO DIGITAL} = 0), ({CODE-DATE} > 1953), "1")...

Copy Column with large amount of data

Mar 01, 2024
I have a Long Text column in my table with a lot of text, likely 20K plus pages. I used formulas to clean this text, removing undesirable characters, extra spaces, etc.  Is there any way to copy the contents of the Formula column back to the Long Tex...

Trim and Substitute '

Feb 26, 2024
I am working on a formula that1. Trims2. Replaces Double Quotes (") with Apostrophes Quote (')3. Replaces Ampersands (&) with 'and'.TRIM(SUBSTITUTE(SUBSTITUTE(DESCRIPTION, '"', ''),'&','and'))The above works, except, if I change it to include the Apo...
Kudos given to
Copyright © 2024 Khoros, LLC