
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 08:13 AM - edited ‎Oct 04, 2023 08:41 AM
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 ?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 04:23 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 04:23 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2023 04:46 PM
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 🚀
