Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### 2 If Statements, 1 is IF/AND Help

Hi there and Happy Friday!I am trying to calculate the time it takes an individual to get a specific type of number at the time they enroll in our program.The formula I have is essentially, "If the individual does not have a preexisting number, calcu...

• 2 Views
• 0 replies
• 0 kudos

### Resolved!IF AND Formula Help!

Hello!I have two fields that I want to meet certain criteria to return a value in another field.Return Value "Late" if field 1: Advanced Record contains "ADVANCED" and Field 2: If Date/Timestamp is after 10p EST otherwise return "On Time" if Date fie...

• 58 Views
• 2 replies
• 0 kudos
by 5 - Automation Enthusiast
Solved

### Work days for Sunday-Thursday

I need to calculate the number of days a ticket was open, but excluding weekends.However, Airtable wont let me change my work days to be Sunday-Thursday.What formula can I use as a workaround, to count all days of the week minus every Friday and Satu...

• 48 Views
• 1 replies
• 0 kudos

### Ft me nahi hai na to be in my heart and

DG mw me nahi hai na to be a great day hoga to be a

• 34 Views
• 0 replies
• 0 kudos

### im accautn is Block support of the day is the best way to get

im accautn is Block support of the day is the best way to get

• 36 Views
• 0 replies
• 0 kudos

### Calculating Hours for time tracking and invoicing

Hi!I'm using an airtable base to calculate my working hours as a freelancer who works in live entertainment and I'm trying to figure out the best way to have a flexible system for different employers' rules for minimum paid hours of a shift, after ho...

• 92 Views
• 2 replies
• 0 kudos

### Formula If or Switch Help

Hey I am trying to set up a formula for the below problem. I am provided with a list of names in the 'home' column and certain entries I need to change to end up like the 'bot name'. I have tried switch/If functions and I just get errors.

• 238 Views
• 5 replies
• 0 kudos

### How to sum values and sort by another field?

Hi all,I have a base table with the transaction history which lists each profile's contribution amount, date, and the fund invested. Each profile is allowed to invest in many funds and can also invest in the same fund multiple times. How do I create ...

• 105 Views
• 1 replies
• 0 kudos

### Resolved!using f-string with filterByFormula

Hi,i am using python-requests and trying to use f-string with filterByFormula here is a simple implementation:hard coding the name worked:   url=f"https://api.airtable.com/v0/{base_id}/{table_name}/" headers={'Authorization': f'Bearer {api_key}', ...

• 91 Views
• 1 replies
• 0 kudos

### Getting the current ID from the form and removing it

I would like to create a script that checks if my employee has already taken an advance on the same day. If it has already been taken, the new record should be deleted. I do this in the form. How can I get the current record ID from the form and dele...

• 97 Views
• 2 replies
• 0 kudos