Help

Formula Help: If/Or Benefits Calculation

Topic Labels: Formulas
290 1
cancel
Showing results for 
Search instead for 
Did you mean: 
beder
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

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

1 Reply 1
Cameron_Kaiser
6 - Interface Innovator
6 - Interface Innovator

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),
“Active”,
“Expired”
)