# Using an OR() Formula from two tables

Topic Labels: Formulas
Solved
641 2
cancel
Showing results for
Did you mean:
7 - App Architect

Hello,

I have one formula field {Ball 1 ?} in the table A . The formula checks another table {Ball 1} via a linked record to see if it contains an attachment. If it does, the computed field writes "Yes", if it is empty, it writes "No". This part works fine.

I have another field (checkbox) named {Balloon 1} in the table A, that I want to add to the logic.

But when I add {Balloon 1} to the condition:

Meaning : If {Ball 1} OR {Balloon 1} is true, then writes "Yes" in {Ball 1 ? } and "No" if it is false.

I receive an error and it doesn't accept the formula.

Here is how I wrote it in the formula field {Ball 1 ?} :

``````IF(
OR(
{Ball 1},{Balloon 1}
),
" Yes",
" No",
)``````

How can I fix it ? Any advice ?

1 Solution

Accepted Solutions
11 - Venus

Hello @Soly

This error is caused by the last comma.

``````IF(
OR(
{Ball 1},{Balloon 1}
),
" Yes",
" No"
)``````

2 Replies 2
11 - Venus

Hello @Soly

This error is caused by the last comma.

``````IF(
OR(
{Ball 1},{Balloon 1}
),
" Yes",
" No"
)``````

7 - App Architect

Thanks @Sho, I can't believe I missed that lol.

In the meantime, I went on to use nested IF's , like so :

``````IF(
{Ball 1},
"Yes",
IF({Balloon 1},
"Yes",
"No"
)
)``````

I'm glad I can now use the OR() you have corrected, as it was my first time experimenting with it.

Have a great day 🚀