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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!