Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Formulas Activity

Calculation for birthday - off by 1 day or not date formatted

I'm trying to create a date formula with the next/upcoming birthdate from a staff profile with Date of Birth. I need this to be formatted as a date so I can use it in a calendar, which has proven to be more difficult than I anticipated. Here are 2 wa...

  • 21 Views
  • 1 replies
  • 0 kudos

IF statement for Payments

Hi, I'm building a formula that says if the first payment date is equal to the month today then show the first payment date otherwise show other payments with the month today.   

Yviana_0-1675390600038.png
  • 21 Views
  • 2 replies
  • 0 kudos

Resolved! Month and Year Formula

Hi Everyone!So I would like a formula field where it shows the month and year of the End Date match the month and year today, say "This Month". I only know month and year separately as shown below however, I want them together in a single-sentence fo...

  • 54 Views
  • 4 replies
  • 0 kudos

Formula for a prefilled form doesn't work

Hello everyone, to create a prefilled form with hidden linked records, I'm using the "Formula for a prefilled form" extension, and I have selected 'by field ID', but it's not working. The primary field of my linked record is a formula and the field i...

  • 43 Views
  • 2 replies
  • 0 kudos

Hyperlinks

HelloIs there a way to include hyperlinks in a base? I am importing data from Excel, where I collected the profile of n individuals and for each profile I have general information (name, education, job title etc) and a link to their LinkedIn page. Wh...

  • 47 Views
  • 1 replies
  • 0 kudos

Show/Hide complete row in a table with "single select".

Hello, I am working with Airtable and Softr. Sometimes it would be helpful to show or hide single rows of a table. So I am looking for a way/formula to easily switch on or switch off (mute) each row in a table with "single select". Sort of like enabl...

  • 25 Views
  • 1 replies
  • 0 kudos

Resolved! Find Most Recent Date across Rollup Fields

Is it possible to use a formula or some other work around to find the most recent date across 4 rollup columns? See photo. I'd like the left column to then show the most recent date, the 4 columns are different donation platforms and it'd be helpful ...

  • 90 Views
  • 4 replies
  • 0 kudos

Utilize Date conditions after creating date token in formula

I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Ta...

Screen Shot 2023-02-01 at 12.05.39 PM.png Screen Shot 2023-02-01 at 12.05.56 PM.png
  • 37 Views
  • 1 replies
  • 0 kudos

splitting content in long form text in a formula

TIA - this community is amazing and so helpful when I can't get my head around these more tricky ones. but I am learning more and more! I have a bunch of method steps for our recipes:COOK THE SALMONPat dry salmon with paper towel, remove the skin and...

  • 55 Views
  • 1 replies
  • 0 kudos

Resolved! Prevent line breaks when empty lines

Hi everybody!I'm trying to modify the formula below so that the empty lines don't show up and don't make a line break with empty lines.For each of the 18 lines I have {FormatX EANX Concatenated} from an other field where {FormatX EANX Concatenated} c...

  • 78 Views
  • 3 replies
  • 0 kudos

Calculating Funding Year

Hi everyone, I am trying to create a formula that will output what funding year a record falls within. I have a field with the dateStart of the funding and another with the dateEnd of the funding. I also have a program start date which is a static fi...

NeptuneDev_0-1675182138206.png
  • 67 Views
  • 3 replies
  • 0 kudos

Student Interactive Leaderboard

Hi all, I am looking to create an interactive leaderboard, where my students fill out a form which relays the results back into a board. I have a rough idea of how to do this, but was wondering if anyone has attempted this before or any leaderboard t...

  • 28 Views
  • 0 replies
  • 0 kudos

Today() Formula

I want to use formula TODAY() BUT I Don't want that it will automatically change with each passing day. I need that the original date that was created, will stay the same. Is there another formula that can do it? 

  • 81 Views
  • 7 replies
  • 0 kudos

Resolved! Handling "Infinity" errors and IF statement formatting

Hi,  I have an issue when using the formula fields in AirTable when using an IF statement.Context: I need the fields to be format as a percentage, or blank if there's an error/infinity.Here is the formula that I want to use in its simplified form, an...

Screen Shot 2023-01-31 at 12.48.43 PM.png Screen Shot 2023-01-31 at 12.50.33 PM.png Screen Shot 2023-01-31 at 12.53.09 PM.png Screen Shot 2023-01-31 at 12.54.50 PM.png
  • 48 Views
  • 3 replies
  • 0 kudos

I need help on a date conversion formula

Hello, I need help on an airtable formula. I have a date conversion formula: but I would like if the table is empty it says "Enter your birthday date" To avoid the error message please my formula : DATETIME_FORMAT(Dateofbirth, 'DD MMMM YYYY')thank yo...

  • 69 Views
  • 4 replies
  • 0 kudos

Resolved! Formula to extract portion of String at Delimiter/Character

Hello, I'm trying to figure out how I might be able to extract a portion of string relative to the position of a delimiter or other character.For example, I have a table of Events that are structured as follows:##### | <Name of Event>.I want to be ab...

  • 62 Views
  • 4 replies
  • 0 kudos

Resolved! Invert the check boxes in a long text field

Over time our long text field with bullet points has evolved into 100+ lines and we're looking for a way to no longer add new bullets at the bottom of the field, but rather at the top. Hence the very logical question: on existing long text fields how...

  • 66 Views
  • 4 replies
  • 0 kudos
J_V by 5 - Automation Enthusiast
Solved