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

Forum Posts

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
Solved
  • 1255 Views
  • 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_0-1705946864907.png
Airtabler1 by 4 - Data Explorer
  • 1069 Views
  • 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
  • 1156 Views
  • 1 replies
  • 0 kudos

Allocate information based on post number

Hello, I just started with Airtable, and to be able to use it, I need solve this problem. I am having a database of volunteers on a national level. I would like to make them write their post number when they apply, and in the base allocate a decided ...

LauraF by 4 - Data Explorer
  • 605 Views
  • 0 replies
  • 0 kudos

Roll up (or look up) of Table B, based on conditions in Table A

Hi there,I'm trying to create a field in a table (say Table B), where its output is takes into consideration a condition based on a field in Table B, rather than the original table it is rolling up from (which I know Airtable has a simple filter for)...

acxp by 4 - Data Explorer
  • 1327 Views
  • 2 replies
  • 0 kudos

Resolved! Formula to return a date based on a "created" date and a variable

Hi all! I am back looking for support with a formula to return a date based on a "created" date and a variable.So far I've been trying to get an IF statements with a DATETIME_FORMAT included to work, but I'm making no progress...My Goal: Create a col...

Spruce_1-1699568683488.png
Spruce by 6 - Interface Innovator
Solved
  • 1344 Views
  • 3 replies
  • 0 kudos

Complex inventory

Hello,  I'm working on an inventory system.  Paired with AirPower, it connects to our shopify storefront to upload on the base what we have in stock on our website.  Once I get this finalized, it will also work in reverse.  We have individual items a...