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

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...

  • 50 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
  • 40 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...

  • 15 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? 

  • 44 Views
  • 5 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
  • 31 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...

  • 54 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...

  • 46 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...

  • 46 Views
  • 3 replies
  • 0 kudos
J_V by 5 - Automation Enthusiast
Solved

Formula field should only display date IF (help)

Hello everyone! I have 3 fields: 1. Date field 2. Formula field that will show a date based on the date field3. Type of issue fieldWhat I want to accomplish is this: the formula field should only show the date IF a certain type of issue in the 'Issue...

  • 51 Views
  • 2 replies
  • 0 kudos

Resolved! Fetching info from within a linked record

Hello, I am pretty new to airtable and have a slight issue with fetching info from a record within a record. With an automation i create a number of records within a record to be able to choose multiple products for the same order number. (Not a lot ...

  • 125 Views
  • 4 replies
  • 0 kudos

Resolved! Date Span Crossover Formula/Script?

HiIf anyone has any ideas about this I would be very grateful - I can't quite see a way through this one!One of the elements of the system I'm building schedules the use of specific tools. I would like to be automatically notified if a tool is double...

  • 70 Views
  • 6 replies
  • 0 kudos
Jon by 5 - Automation Enthusiast
Solved

Resolved! Conditional formula

Hi, I am trying to create a formula to work out meal allocations for works at a festival site.Currently I have date fields for 'ARRIVAL DATE' & 'DEPARTURE DATE' and a field for 'DAYS ON SITE' which uses the formula DATETIME_DIFF({DEPARTURE DATE},{ARR...

  • 43 Views
  • 4 replies
  • 0 kudos

Resolved! Date Counting

Hello!I have a list of records that all have a start date and end date column for a number of employees.  I am wondering if there is a way to calculate the number of employees on a given day.  All the employees have different start and end dates.  So...

  • 72 Views
  • 2 replies
  • 1 kudos

How many times a linked record has occured

I'd like to count how many linked records have occurred with another linked record. I have a table where each record is a contract between a company and a governmental entity. The company's column is a linked record and the entity's name is also a li...

Motlaq_AlMutair_1-1674915234669.png
  • 43 Views
  • 2 replies
  • 0 kudos

Resolved! Costum ID

Hi there. I'm trying to make a custom auto number. The constant is kasse 00 and then want the autonember to be kasse 001, kasse 002, kasse 003 and so on. Can anybody send me in the right direction?And off cause will there be a problem when I reach ka...

  • 64 Views
  • 3 replies
  • 0 kudos

Resolved! Split Formula

Hello,I have a rollup field with the following output:FirstName1  Last Name1- XXXX Title Company , First Name2 Last Name2 - XX Title CompanyWithout going back to the original table to pull the "XXX Title Company"  I need a formula to help split and d...

  • 63 Views
  • 2 replies
  • 0 kudos