Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

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

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

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

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

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

• 212 Views
• 4 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 ...

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

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

• 85 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?

• 230 Views
• 7 replies
• 0 kudos

### Resolved!Static Aging of Status

I am trying to create a formula to calculate the number of days a specific status is active. For example, how many days the ticket is "On Hold". The need is to calculate the number of days the ticket was actually active, in other words the difference...

• 80 Views
• 2 replies
• 0 kudos