Formula Help
I am trying to use an IF contains formula to look at the assignee column and the notified column for two different names and continue to get #unparseable. Does anyone have insight or the correct formula?
Answers
-
Could you post your formula? I will take a look at the syntax to do a root cause analysis!
-
I am trying to use an IF CONTAINS formula
=IF(CONTAINS("Person", Assignee@row + " " Notified@row))
-
You can follow this formula
=IF(CONTAINS("Jacket", [Clothing Item]:[Clothing Item]), "True", "False")
After your quotes, you need to add a + symbol if you are trying to join text
You are missing your TRUE arguement.
...
-
Agreed with heyjay. As a helpful tool moving forward, when you are typing a formula in smartsheet, it typically oulines the synthax needed to have a successful formula. Referencing this will help you avoid missing terms in the future :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!