If/Or Formula

Hi there,

I have this formula: =IF(OR([ Company’s intellectual property Co-owned]@row = "No", [ Company’s intellectual property Co-owned]@row = "Unsure"), [First Name]@row + [Last Name]@row + " knows or believes that none of " + [Name of Company]@row + " is co-owned by another person or entity.", IF([ Company’s intellectual property Co-owned]@row = "Yes" + [By whom?]@row + " is the co-owner of the Company’s intellectual property. Note to reading attorney: If the contract for co-ownership was not provided by the client, ask for it directly.", ""))


Note: The first part If/Or is populating correctly on the " No or Unsure" logic, but the "Yes" is not.

I need assistance to get the "Yes" function to populate too.


This is my Output Information:

If Company’s intellectual property Co-owned = No or Unsure, then show below:

[First Name] [Last Name] knows or believes that none of [Name of Company] is co-owned by another person or entity. 

If Company’s intellectual property Co-owned = Yes, Then show below:

[By whom?)] is the co-owner of the Company’s intellectual property. Note to reading attorney: If the contract for co-ownership was not provided by the client, ask for it directly.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!