Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Formulas Activity

Can't Get Nested IF AND Statements to Work

Hello Airtable community!I inherited a pretty robust Airtable system from a predecessor and have been working to revamp it, but my formula skills are not as good as the person who came before me, and I've been struggling to get IF AND statements to w...

  • 70 Views
  • 2 replies
  • 0 kudos

Resolved! Removing NaN where + and - values can exist

Hi there! I am trying to remove NaN values from a formula field where both positive and negative values exist. This is in an effort to clean up two extensions: One chart indicating the number of each value's occurrence and one number where I am tryin...

  • 65 Views
  • 2 replies
  • 0 kudos

Resolved! switch or nested IF for conditional commission calculation

Hi,I'm trying to create a table to track income and the records feed from different tables using automations which are assigned a deal type as they're created. If they're type A the commission is 15% of the payment amount, if they're type B the commi...

  • 124 Views
  • 8 replies
  • 0 kudos
HannahS by • 6 - Interface Innovator
Solved

Resolved! Calculating a ratio

Hi there,I'm looking for a formula to automatically calculate the Venue and Producer split of the Budget and Budget Committed as per the "Deal." However, at present, the "Deal" field is a text entry, and I wondered what the best way to achieve this i...

Deal.PNG
  • 104 Views
  • 3 replies
  • 0 kudos
hsat by • 5 - Automation Enthusiast
Solved

Resolved! Highlight a Line With Overdue Date

Hi There, I know I should already know this but I always get nervous when dates are involved. I want to be able to highlight either a field or a row when a task in the row passes the deadline. I don't need to know any other information like how many ...

  • 115 Views
  • 4 replies
  • 0 kudos
SparKey by • 5 - Automation Enthusiast
Solved

Enter last appointment date forumula

I am trying to create a formula that will take the latest date from a linked field (Appointments) and enter the latest date in a new field called "Last Appointment." I tried to generate a formula using the AI which gave me this formula:DATESTR(ARRAYS...

  • 149 Views
  • 1 replies
  • 0 kudos

Resolved! How to fix formula to only calculate if input value is 0 or not empty?

I'm having a really hard time with making a formula field only calculate a value if the input field is not empty, including if it's 0. For some reason Airtable seems to treat 0 and empty value that same.Here is my current formula: IF({Monthly Actual}...

  • 154 Views
  • 3 replies
  • 0 kudos
dnn6 by • 4 - Data Explorer
Solved

Resolved! Return a numerical value based on a Single Select Dropdown

Hi there. I'm trying to create a formula that returns a numerical value (price) based on a dropdown field. So, if "Option Zebra" is selected in the dropdown, the formula returns a value of 250. If "Option Lion", then the formula returns a value of 30...

  • 168 Views
  • 3 replies
  • 0 kudos

Formula to return text and URL

I have a table of books with the following columnsBook Titleyear publishedAmazon LinkBookshop.org LinkI want to create a field that returns Book Title (Year Published) Amazon Bookshop, where the "Amazon" is linked abd "Bookshop.org" is linked.Is it p...

  • 157 Views
  • 3 replies
  • 0 kudos
LP2 by • 4 - Data Explorer