Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

Change a Lookup field to a Formula field?

Winged Foot Condominium Assn dBase.Base has 2 Tables named Maint Fees and Winged Foot AssnMAINT FEES TABLEMaint Fees table has 5 fields: Unit Name > [$] 2022 Maint Fees > [$] 2023 Maint Fees > [Linked] Winged Foot Units > [A] NotesMaint Fees table ha...

  • 24 Views
  • 2 replies
  • 0 kudos

Combining Fields and additional text based on Field Value

I have the following FieldsTemplate Type (options are either TEXT Only or With Weblink)Title LineCopyName of LinkURL When user selects Template Type Text Only, I need a field that will display the full text and contents:{"iconName":"safety","text":"C...

  • 27 Views
  • 1 replies
  • 0 kudos

Resolved! Summing rows

Dear communityI need a formula to sum number rows. This seems a bit difficult, but maybe I'm just dumb...I just need to summarize #Beløb F and #Beløb S into #Beløb. I am doing it manually right now.Basically: #Beløb F + #Beløb S = f BeløbCan anybody ...

Skærmbillede 2023-06-08 kl. 11.41.13.png Skærmbillede 2023-06-08 kl. 11.41.13.png
  • 40 Views
  • 2 replies
  • 0 kudos
KlaDa by 5 - Automation Enthusiast
Solved

Merging date fields

Hi everyone!I have two lookup fields, each one of them with a list of dates, and I need to merge them in the same field, keeping the date format. I've been testing with some formulas like concatenate, arrayjoin, dateformat... but I haven't been able ...

  • 21 Views
  • 0 replies
  • 0 kudos

Resolved! How to combine fields based on the value of another field ?

Hello, I am looking for a way to combine five fields (address, second address line, zip code and city) to a new multiline text field when another field "second zip code" has a value. So here is an example of the five fields: Address: 220 Miller Avenu...

  • 729 Views
  • 2 replies
  • 0 kudos

Resolved! concatenate formula issue

Hi everybody I am new to airtable and trying to put a class scheduling together. I have mostly been using the template and learning through trial and error. Now I have produced a weird error that does not seem to impact the functionality but is very ...

  • 614 Views
  • 2 replies
  • 0 kudos
JPE by 4 - Data Explorer
Solved

Resolved! Checkbox Count as Progress Bar

Hey! I have 3 checkbox fields that indicate the completion of a task. I want to show completion of the tasks using the newly released progress bar on the Percent tab, but without having to manually type in the thirds (1/3, 2/3, 3/3). If I use a formu...

alebarbosacial_3-1686235338094.png
  • 803 Views
  • 8 replies
  • 0 kudos

Resolved! IF Formula assistance

Question on the following formula.  I have tried just about anything and everything to get this formula field to only calculate the score based on after the date.  The formula works perfectly fine without using any date fields. Form type (single choi...

  • 256 Views
  • 5 replies
  • 0 kudos

Link to another record across multiple tables

Hello community! We use airtable as an ATS (applicant tracking system) and now would like to extend it to project management.I have 2 different tables: candidates and jobs. I now want to create a new task table (classical kanban project management) w...

  • 185 Views
  • 2 replies
  • 0 kudos

Primary Field as a joint array

is there a way of adding a joint array, concatenate to my primary field (containing Email and Full Name), but still be able to link to that table using email only. in other words, my contacts have different emails, and currently primary field is thei...

  • 168 Views
  • 1 replies
  • 0 kudos

Resolved! How to Format Dates in a Rollup field with multiple dates

Hi everyone,I've been searching airtable forums for hours yet I can't find a solution that clearly explains what I need to do to achieve my desired results. There are different answers talking about using MIN() or something other formula, but I can't...

Scribbles__0-1686012770090.png
  • 214 Views
  • 2 replies
  • 0 kudos

Markdown code showing in email body for some recipients

Hi all,I'm sending out emails via Airtable and some (but not all) recipients are noticing a very weird problem. The URL code shows the markdown text instead of the URL link, ie., it shows [TEXT](url) instead of TEXT.I thought it might just be a probl...

  • 192 Views
  • 3 replies
  • 0 kudos

Resolved! Extract info from a Long Text field

Hi, I have a long text field with the info bellow and would like to extract the infos in bold to different field but cant find a formula to help me with. Thanks in advance for any help guys.This is the text I have in the long text field (its in portu...

  • 72 Views
  • 2 replies
  • 0 kudos

Turning <p> and </p> into line breaks in a field

Hello, all. I am importing a CSV file into Airtable. Some of the CSV data ends up as Long Text fields in Airtable, and consists of blocks of text with multiple paragraphs. It comes in with <p> and </p> indicating these paragraphs.In Airtable, the <p>...

  • 87 Views
  • 1 replies
  • 0 kudos