Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Count occurence of each unique in a Rollup

Hi,Let's say I have a People table with Name A, Name B, Name C.Another Table "Sports", which links Name A with Football, Name A with Football (again), Name A with Basketball, Name B with Basketball, Name B with Basketball, etc.In the People table I w...

• 53 Views
• 2 replies
• 0 kudos

8653906699

• 54 Views
• 0 replies
• 0 kudos

8653906699

• 35 Views
• 0 replies
• 0 kudos

### Number of changes

HiIs it possible to count the number of changes or modifications that have been made to a specific record?Rgds

• 76 Views
• 2 replies
• 0 kudos

### Resolved!Using Mapped Values in a Formula Field

I have a “Campaign Name” table that contains a “Product” field (which uses abbreviations).The “Campaign Name” table has a formula field which uses the “Product” values (along with other fields) to generate a campaign name.Our request form (on the “Ca...

• 61 Views
• 2 replies
• 0 kudos

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

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

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

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

• 104 Views
• 2 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

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

• 59 Views
• 0 replies
• 0 kudos