Skip to main content

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 ?

Hello @Soly 

This error is caused by the last comma.

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

 

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 🚀

 

 

 

Terms & ConditionsAccessibility statement