Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

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

  • 5 Views
  • 0 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...

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

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

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

Screenshot 2024-06-19 at 8.37.52 AM.png Screenshot 2024-06-19 at 8.49.01 AM.png Screenshot 2024-06-19 at 8.51.34 AM.png Screenshot 2024-06-19 at 8.51.22 AM.png
  • 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.  

Sarah1_0-1718754695037.png
  • 244 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 ...

Picture1.png Picture2.png
  • 106 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