Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### 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...

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

• 33 Views
• 0 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

• 29 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

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

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

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

• 100 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}', ...

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

• 94 Views
• 2 replies
• 0 kudos

### Resolved!Formula to replace question mark with an apostrophe in a text field

My text fields imported from excel have a question mark where an apostrophe should be.  Is there a simple formula to correct this?

• 251 Views
• 7 replies
• 0 kudos