Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Formula cell maodifies text

Hi! I'm having trouble with a formula where it brings back text and adds " " when it is done. Here is the layout:Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}Column 2: Linked to another table, displays {Client} n...

ARiios by 5 - Automation Enthusiast
  • 2 replies
  • 2 kudos

Need help regarding advanced formula usage

Hello there,I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. I have tried using nested IF statements; but I am running into so...

elija6266 by 4 - Data Explorer
  • 2 replies
  • 0 kudos

Formula Help!

Hello, I am new to formulas so I was hoping someone can help me with the formula below. I am trying to create two new formula fields.In the first new formula field, I am trying to do the following: If the 'Category' field is Finance and the 'Owner' f...

coco-chen by 4 - Data Explorer
  • 4 replies
  • 0 kudos

Adding sums between 2 dates

I need to be able to total up sums per line from an original start date for a full year after.Example:  Original  start date                   Amount paid-1, amount paid-2, amount paid-3, etc.                  This would be calculated for 1 year, the...

Does ANY value from Field A match ANY value from Field B?

Hi, everyone! It's my first post, and I'm relatively new to Airtable and to databases more broadly. Hoping for some help.I'm using a base to organize staff for a conference. Volunteers are attending some sessions and working other sessions. I have a ...

xtj by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Formula to display most recent input based on multiple field

Hi there - I am looking to create a column that will essentially lookup the field values of columns Q1 - Q4 and output the latest number.We input quarterly projections and want to be able to identify the most recent number by looking at 1 field ("lat...

ta2530 by 5 - Automation Enthusiast
  • 2 replies
  • 0 kudos

Pull multiple values into one cell

Hi Airtable Community! I am looking for a way to pull values from multiple columns into a single cell. The setup is as follows: I have a list of countries, and each country has a team comprised of people from multiple departments. The departments eac...

Airtabler1 by 4 - Data Explorer
  • 2 replies
  • 0 kudos

IF <X> Range = checkbox

I'm new to Airtable and I need a formula to check a box from a form submission.IF >=0, 3>= then True (Checkbox 1)IF >=4, 6>= then True (Checkbox 2)IF >=7, 9>= then True (Checkbox 3)IF >=10, 12>= then True (Checkbox 4)I have an automation that sends a...

ksaycdc by 4 - Data Explorer
  • 1 replies
  • 0 kudos