Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Using an OR() Formula from two tables

Topic Labels: Formulas
Solved
Jump to Solution
1236 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"
)

 

Soly
7 - App Architect
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 ðŸš€