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

Formulas Activity

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

  • 25 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
  • 32 Views
  • 2 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...

  • 42 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...

  • 74 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
  • 83 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
  • 84 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 ...

  • 173 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...

  • 77 Views
  • 1 replies
  • 0 kudos

Trim and Substitute '

I am working on a formula that1. Trims2. Replaces Double Quotes (") with Apostrophes Quote (')3. Replaces Ampersands (&) with 'and'.TRIM(SUBSTITUTE(SUBSTITUTE(DESCRIPTION, '"', ''),'&','and'))The above works, except, if I change it to include the Apo...

  • 58 Views
  • 1 replies
  • 0 kudos

connection of softr and airtable.

we have a problem with the connection of softr and airtable. We have a part in softr where people can add new data and we need that data to be in airtable. However, in airtable the place where the data should go to is linked with other tabs.Since it’...

  • 102 Views
  • 1 replies
  • 0 kudos

Count number of times a word comes up in a linked records list

How can I count the number of records in the list "Attended Session & Challenge" that are specifically only from 2023? The attendance is based on a form they fill in that is in a different tab in the same workspace. help would be very appreciated! Th...

Screenshot 2024-02-26 at 11.40.05.png
  • 74 Views
  • 2 replies
  • 0 kudos

Resolved! Return multiple values from all columns which meet criteria

Hi all,I have formulated columns Apple, Orange, Banana, and the formula produces "Y" or "N" values. I want to create another column that will return the name of the column if their value is "Y". Is there any way to do this?I have tried nested IF form...

Screenshot 2024-02-26 at 4.02.13 PM.png
  • 129 Views
  • 4 replies
  • 0 kudos

Linked two Tables with filter function

I create a form (interface in Airtable) to collect information from user and store in "Table A". Output fields include "Age", "Location", "Claim", "Special", Compo". I have another "Table B" to have above 5 fields and addtional "diagnosis value" fiel...

  • 99 Views
  • 5 replies
  • 0 kudos

Pulling Max Value

I have a table where different group clients submit weekly weights on a form.I'm calculating "starting weight - weekly weight = X". With each submission, I send them an automated email that records what their weight loss is, BUT even though their wee...

  • 106 Views
  • 1 replies
  • 0 kudos

Format date fields

Hi everyone, would you please tell me how to convert a multiple date string field (i.e., 2/11/2024, 3/3/2024, 2/19/2024, 2/25/2024) to the correct format date field that reflects all the dates in the string field? Please note that the string field me...

  • 127 Views
  • 3 replies
  • 0 kudos

How to search for what's missing?

Hi all, I'm working on a donor management system for a non-profit org.  Donors make pledges to give $x on x recurring basis, usually something like $50 a month.I've got a table for Donors, one for pledges, and one for donations.I need to have a way t...

  • 131 Views
  • 4 replies
  • 0 kudos

Split text to multiple columns

I want to separate the following text in different columns :Column A : @Ben//test-bug//Feb 22, 2024 3:54pm UTC//Budget//Test again//Test again//ModerateColumn B : @BenColumn C : test-bugColumn D : Feb 22, 2024 3:54pm UTCColumn E : BudgetColumn F : Te...

  • 107 Views
  • 1 replies
  • 0 kudos

Stop the countdown when status change to sent" or "refund"

Hi!I have a countdown for our warranty cases, which needs to be completed in the 45 days or less. Our customer fills out the Form, and the countdown stars when the Form is submitted. So the first field is "Form date" DATETIME_FORMAT(CREATED_TIME(), '...

  • 113 Views
  • 1 replies
  • 0 kudos