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

  • 57 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
  • 238 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
  • 105 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

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

sample1.png sample2.png
  • 97 Views
  • 2 replies
  • 0 kudos