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

Formulas Activity

Resolved! Issues With A Nested IF Statement

Hi, I am hoping that someone might be able to help with a nested IF Statement I have a field that determines the size of an advert. I want another field to list the price for the advert based on the selection in the first column.This is the If Statem...

  • 72 Views
  • 2 replies
  • 0 kudos

Automatically select all results in linked field

Hi everyone!I use Airtable to track event time logs (like a clock in/out system).  I attached the base structure to this message.How can I make the "totalMins" linked field (linked to "mins" in the "timelogs" table) automatically select all of the re...

gavin_0-1734029346011.png gavin_1-1734029354867.png
  • 95 Views
  • 1 replies
  • 0 kudos

Integrating RingCentral to Airtable

Hi,I have a field that has my clients' phone numbers. I also have a RingCentral account that I make phone calls from. I would like to be able to click on the phone number and make a phone call automatically from the RingCentral app. Does anyone know ...

  • 148 Views
  • 3 replies
  • 0 kudos

Resolved! Formula giving #ERROR! instead of empty cell

What is wrong with my formula that it is producing "#ERROR!" instead of an empty cell when {Most Recent Completed Event Date} is blank? DATETIME_FORMAT(IF({Most Recent Completed Event Date}, DATEADD({Most Recent Completed Event Date}, 9, 'month'), ""...

  • 173 Views
  • 5 replies
  • 0 kudos

Sum number of records by user in a different table

Hello AirTable community! I am trying to create a separate table that takes just the created by name, their email, and the number of approved records they have (in this case, approved is referring to any record in the original table that receives a c...

  • 235 Views
  • 9 replies
  • 0 kudos

Resolved! Date Selection from three options

I'm tracking book publications and each of the titles in my database will have several dates for different formats - Hardback, paperback, ebook and Audio...I'm trying to create a formula that will automatically select the earliest of these dates so t...

  • 184 Views
  • 2 replies
  • 0 kudos

Resolved! IF Formulas Help

Hello. I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).Th...

  • 547 Views
  • 2 replies
  • 0 kudos

Resolved! Combining Dates from Multiple Fields

We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remai...

  • 309 Views
  • 5 replies
  • 0 kudos