IF(Contains)
I am using the IF(Contains formula to look at values in the Numbers to Include column, which is a multi-select drop down column, and it if finds the value to add a number to the Office Phone column.
=IF(CONTAINS("Main Office: 303-932-0757", [Numbers to Include]@row, "303-932-0757", ""))
This formula is in the Office Phone cell for the current row.
I am getting an Incorrect arguments error.
Best Answer
-
Got it figured out with help from other responses to this type of questions. Used IF(HAS) instead.
Answers
-
Got it figured out with help from other responses to this type of questions. Used IF(HAS) instead.
-
Awesome to hear you found a response, @Becky Wilson!
Please feel free to post your solution as well.
Cheers!
Join us at Smartsheet ENGAGE 2024🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 297 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!