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”
)
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”
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.