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

Forum Posts

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
  • 114 Views
  • 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
Solved
  • 172 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
  • 208 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
  • 236 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
  • 190 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
  • 298 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
  • 370 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...

Resolved! Help! Trouble with date formulas #ERROR! and NaN

Hello! I'm slowly learning how to use date formulas, but I have hit a wall in my ability to troubleshoot.I have two date formulas causing me trouble.1) My Rush Due Date is displaying #ERROR! when "Rush" checkbox is not checked.DATETIME_FORMAT(IF(Rush...

Spruce_0-1697472652432.png Spruce_1-1697472791463.png
Spruce by 6 - Interface Innovator
Solved
  • 529 Views
  • 4 replies
  • 3 kudos

Sum and divide fields into two different categories

Hello,I program a film festival and we use Airtable to organize the submission we receive. This year we have two different programming teams that should watch half of the submitted projects. I wanted to create a formula that would calculate the total...

BxlPFF by 4 - Data Explorer
  • 284 Views
  • 1 replies
  • 0 kudos

Nested IF plus.... What else do I need? 😳

Hi All! I am still new to Airtable and writing formulas and (hopefully) this is an easy question.I am trying to write a formula that will display text that matches the "checked" state of 3 different checkboxes, and also will display "New" if none of ...

Spruce_0-1696519610393.png
Spruce by 6 - Interface Innovator
  • 582 Views
  • 3 replies
  • 0 kudos

Resolved! Conditional Coloring for the Record "pills" in a lookup field

Working on costuming for a film - have 4 main tables of Actors, Costumes, Scenes, and Characters.There's a lot of table to table referencing going on w/ lookups...But one thing I would LOVE to be able to do:When looking at the COSTUMES table (charact...

Can these colors be conditional.png
seanpeter2 by 5 - Automation Enthusiast
Solved
  • 492 Views
  • 3 replies
  • 1 kudos

Splitting Expenses as inventory is distrubted

I am looking for a way to split expenses amongst people in our company without duplicating the total. We purchase company merch/promo items and that expense goes under our expense table and is assigned to 1 of our 7 offices, or corporate. We assign a...

Resolved! IF + DATETIME_DIFF Formula Help! 🙏🏼

I have a lot to learn in terms of building formulas, and I'm found myself stuck and not sure what I'm missing.What I'm trying to accomplish:If the Completed column checkbox is ticked, display "Completed"If the checkbox is not ticked, display the time...

Spruce by 6 - Interface Innovator
Solved
  • 541 Views
  • 4 replies
  • 1 kudos