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 🚀

 

 

 

Reply


Terms & Conditions