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

Formulas Activity

Formula for 90 days after, up to a certain date.

Hey! I'm trying to figure out how to add a portion to a formula that would ensure that it's set for 90 days after a particular field, or before June 1st. The current formula pulls from a date field for when they registered (Date Registered), and adds...

  • 23 Views
  • 1 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...

  • 50 Views
  • 4 replies
  • 0 kudos

Resolved! Airtable button triggering webhook Twice

Hey guys, I have a button in my Airtable that triggers a Zap in Zapier. I'm using this code: { "https://hooks.zapier.com/hooks/catch/14888220/30r6035/?recordID=" & RECORD_ID() }, but it's triggering the Zap twice. I'm also using multiple buttons, and...

  • 105 Views
  • 3 replies
  • 0 kudos

Resolved! Scoring system where number of criteria scored is variable

Hi,We have a scoring system that rates functionality in an interface. So as not to bias the total score, if the functionality isn't present we ask evaluators to give it a -1.In Excel, the final score is determined by a formula that:Counts the number ...

  • 110 Views
  • 4 replies
  • 0 kudos

Resolved! IF formula assistance using dates

Hello! I'm creating an Airtable base to manage book club meetings. I have a column for the meeting dates (DD/MM/YYYY) which take place once per month. I'd like to have a "Reading Status" column that uses a formula to create the following labels:"All ...

  • 91 Views
  • 2 replies
  • 0 kudos

Deduplicating names in a text array

Hi,I hope you can help me, I've searched everywhere and I can't find an answer to my problem.I work for a training organization. I have a table with students. A table with training session dates. And a table with speakers.In the dates table, I make a...

  • 223 Views
  • 5 replies
  • 0 kudos

Resolved! Extract email from User Field

Is there a way to extract a users email address from their account info?Context...I have a form built in "interfaces" and have toggled on "see who submitted response".Ideally I'm trying to extract the domains for the users as a method to sort with di...

  • 110 Views
  • 2 replies
  • 0 kudos

Statute of limitations countdown

Hello, I am setting a legal case tracking base and I am trying to do something where:1: When I input the date of incident, it automatically calculates two years from that date2: I would like to have a table that also has a countdown until we reach th...

  • 85 Views
  • 1 replies
  • 0 kudos

Resolved! Using a formula to append strings

Is there a way to append data in a field? Let's say I have a long text field called "Campaigns" which will contain the different campaigns that a customer have agreed to through our emails. Is there a way to preserve the previous text and basically a...

  • 91 Views
  • 1 replies
  • 0 kudos

Resolved! Converting word responses into intergers

Hi everyone, I am new to the Airtable and I'm excited to be part of this community. May I apologise in advance if I don't use the correct technical terminology.  I design surveys, impact assessments and evaluation tools for a criminal justice charity...

  • 186 Views
  • 7 replies
  • 0 kudos

Resolved! Make.com formula for Airtable

Hi! I have data coming in from a webhook to Make. I am trying to create a formula in Make to search Airtable for number of times an email appears in a field on a table and limit the number of submissions to Airtable. For example, I want to limit the ...

  • 223 Views
  • 8 replies
  • 0 kudos
lmac by 5 - Automation Enthusiast
Solved

Resolved! Converting partial year and text to year/month

Hello! I have a large set of dates that are a partial year and month, and would like to convert this to a final date of the month format. Examples:Data I HaveDesired Format24-Apr2024-04-3024-Aug2024-08-3023-Dec2023-12-31I've tried concat using LEFT( ...

  • 226 Views
  • 1 replies
  • 0 kudos

Dates "sheet"? Update records based on one date

I want to create a "sheet" timetable that creates new dates using a formula based on one date that is inputted. I know there's probably a better way to say that so please disregard my ignorance. Here's what I want to happen...I input the "Class Start...

  • 120 Views
  • 2 replies
  • 0 kudos

Resolved! Day date glitch

why does a 'day date' formula, based on a 'start time' return a day as the day before, when the start time is before 8am? Here is my formula column which is based on my start day/time fieldDATETIME_FORMAT(Start,"D-ddd") 

  • 196 Views
  • 2 replies
  • 0 kudos
GGA by 4 - Data Explorer
Solved

Formula to look for scheduling conflict

Hey Airtable! I'm looking for some complex scheduling help. I'm using Airtable to schedule a multi stage music festival, and we're hoping to have a formula that will look for scheduling conflicts for individual performers at specific times. I have an...

  • 155 Views
  • 3 replies
  • 0 kudos

Lookups, Rollups, and Formulas producing comma after unique values

Hello,I'm pulling in purchase order data for my company, and have a "Vendor Management Team Partner" associated with each purchase order record.I'm also reconfiguring these POs in a separate table, such that the email address of the PO requester is t...

mtardiff_0-1709913200332.png
  • 170 Views
  • 5 replies
  • 0 kudos

Formula to auto generate data in new cell

I am using Air Table to capture costs per garment style and there are 12 versions of the costs that are available to use based on importing tariffs and shipping modes. These 12 costs are hard keyed into the base. I would like to be able to make the c...

  • 140 Views
  • 1 replies
  • 0 kudos