Help
Formulas
cancel
Showing results for 
Search instead 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...

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

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

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

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

  • 100 Views
  • 2 replies
  • 0 kudos
KGB 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...

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