Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula Help: If/Or Benefits Calculation

Topic Labels: Formulas
187 1
Showing results for 
Search instead for 
Did you mean: 

Hi! I’m trying to calculate a formula field that looks at 2 different fields (# Benefits Remaining) and (End Date) and returns either “Active” or “Inactive”. If the # Benefits Remaining is >=1 OR the end date is after today, it is active. Some of our benefits have a specific number available and others last for a specific duration of time.

Here’s what I have so far - what am I doing wrong?

TODAY()<{End Date}),
({# Remaining}>=1),

1 Reply 1

You closed your OR() function on itself after {End Date}. The structure of OR() is OR(this, that, etc.), whereas you have it as OR(this), (that), (etc.)). While you can technically add the parantheses for each value if you want, it’s redundant and in this case you’d need to make sure you opened “this” with a paranthesis too. You also have an extra comma at the end - you only need to place them between values. This will work:

IF( OR( TODAY() < {End Date}, {# Remaining} >= 1),