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

Forum Posts

'If today is within (date range)' formula

Hi, I'm trying (and struggling) to create a formula that allows us to filter by 'people who are currently contracted by us'. We have a start date and end date column within the table, so ideally I'd like to add a formula that allows us to filter base...

graceallen by 4 - Data Explorer
  • 685 Views
  • 3 replies
  • 3 kudos

Edit history of a field or formula

Is there a way to see/track who has made edits to a formula or field? This feature is very helpful for viewing individual records, but it'd be even better if I could view who is changing formulas.

e2laurel by 5 - Automation Enthusiast
  • 687 Views
  • 2 replies
  • 0 kudos

Adding sums between 2 dates

I need to be able to total up sums per line from an original start date for a full year after.Example:  Original  start date                   Amount paid-1, amount paid-2, amount paid-3, etc.                  This would be calculated for 1 year, the...

Multi likes help me

I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a l...

Sarahhh1 by 4 - Data Explorer
  • 583 Views
  • 0 replies
  • 0 kudos

Locate Completed Record

Hi, where do I find completed record when it disappeared in the table?

reign by 4 - Data Explorer
  • 744 Views
  • 1 replies
  • 1 kudos

Formula to work out business hours between two date fields

Hi guys,I have 2 columns in Grid view, each with date and time. One is a "Created" column, the other is a "Resolved" column.I am wanting to have a formula to put into a 3rd column / field to work out the business hours between the two other fields. H...

Untitled Base_ Table 1 - Airtable and 3 more pages.png
CameronG by 5 - Automation Enthusiast
  • 829 Views
  • 0 replies
  • 1 kudos

Resolved! Adding certain statuses

Hello Community! I need some guidance... I have a few columns with fields that are Single Select and one of the options is "COMPLETED". I am looking for a way to create a formula for it to add "how many COMPLETED fields" I have for that record... For...

Mike_Lopez by 5 - Automation Enthusiast
Solved
  • 4038 Views
  • 5 replies
  • 2 kudos