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!
If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.
Thanks!
Nick Stafford
-
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 :)
If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.
Thanks!
Nick Stafford
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!