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

Formulas Activity

How to use checkbox with nested IF and AND statement

Hello,  I'm trying to create a formula that will return "Check Other Income" if the Contract * .25 > Other income and if Other Income Verified is checked it will return "Income Verified" This is how I have written the formula:IF({Other Income} > (Con...

  • 44 Views
  • 1 replies
  • 0 kudos

Limit data submission by user

I would like to limit the number of rows created in a table. I am planning to have a limited data entry period with 100 users where each user can only put in 10 rows of data. How would I achieve this with Airtable?

  • 29 Views
  • 1 replies
  • 0 kudos

Resolved! IF AND BLANK formula not working for attachment field

Hi. I'm struggling with a formula to include a blank attachment field as part of 3 AND conditions. I'm testing this in my base before I put the AND part into a make.com airtable trigger module.At the moment, I have this:  IF( AND( {Ind Doc}!=BL...

  • 110 Views
  • 4 replies
  • 0 kudos
hauwi by 6 - Interface Innovator
Solved

Resolved! Copy Column with large amount of data

I have a Long Text column in my table with a lot of text, likely 20K plus pages. I used formulas to clean this text, removing undesirable characters, extra spaces, etc.  Is there any way to copy the contents of the Formula column back to the Long Tex...

  • 110 Views
  • 3 replies
  • 0 kudos
K_B1 by 4 - Data Explorer
Solved

Resolved! Formula in primary field To create id: Autonumber-year

I'm super new to airtable and I've been searching for the answer to this and I can't seem to find what I am looking for- likely because I don't know the right terminology but I have a table in my base and I want the primary field to auto populate eac...

  • 142 Views
  • 2 replies
  • 0 kudos
AmyM by 4 - Data Explorer
Solved

countdown in hours

Hello,we would like to find a formula to count down 24 hours and end at 0 or if possible marked "canceled".if anyone can help us i will be really gratefulthanks in advance

  • 78 Views
  • 1 replies
  • 0 kudos

Prefilling forms with Link to another record

I am facing difficulty in prefilling forms with 'Link to another record data type'Data is occasionally getting printed when the data type is 'Link to another record' with 'Allow linking to multiple records' switched 'ON' What changes should I make so...

mshah72_0-1709137006213.png
  • 163 Views
  • 7 replies
  • 0 kudos

Date formula help!

Hi! I'm trying to set up a formula for a "Production Slack Reminder" that would be based on the "Send Date." If the "Send Date" falls on a Tuesday, Wednesday, Thursday, or Friday, the "Production Slack Reminder" should happen the day before the "Send...

  • 86 Views
  • 1 replies
  • 0 kudos

Resolved! workback from date field using Dateadd, Workday, and a Holiday String

I am struggling to add a holiday string in an existing worback formula that changes the date based on another field. I applied Workday successfully but cannot apply {Holiday String}&"" SWITCH({Channel Size},'Large Email', WORKDAY(DATEADD({Launch Date...

  • 137 Views
  • 4 replies
  • 0 kudos

Resolved! Using IF, and AND and OR formula using emojis

I struggling to correct a formula where I want the return value to appear based on IF AND statements.Goal I am trying to achieve:I DO NOT want the phone emoji to appear in the “follow-up” column if the “lead score” is below 5 (Eg: 0, -5, -15).Here is...

Screenshot 2024-02-26 at 5.47.51 PM.png Screenshot 2024-02-26 at 5.44.41 PM.png
  • 127 Views
  • 2 replies
  • 0 kudos

Separating multiple data entries in field

Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

Screenshot 2024-02-26 164505.png
  • 128 Views
  • 3 replies
  • 0 kudos

Adding a date to an IF statement

Hey all, I could use some help and I'm hoping this isn't too difficult. I am trying to add a formula that compares an event date to the date of the next time change. If it is before the date of the time change, it runs one formula, if after, it runs ...

  • 260 Views
  • 5 replies
  • 0 kudos

Calculate Friday of the week before start of next month

Hiya! I'm relatively new to Airtable and need help with this formula. I need to find a formula that displays the date for the Friday of the week before the start of the next month based on a date in another field. Would also love to know what each el...

  • 104 Views
  • 1 replies
  • 0 kudos