Help

Using an OR() Formula from two tables

Topic Labels: Formulas
Solved
Jump to Solution
388 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Soly
7 - App Architect
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
Sho
11 - Venus
11 - Venus

Hello @Soly 

This error is caused by the last comma.

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

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hello @Soly 

This error is caused by the last comma.

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

 

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 🚀