Need help with #unparseable error in checkbox formula
I am very new with smartsheets but i am familiar with excel and i can see the similarities and differences. I am trying to create a formula in a checkbox to automatically check the box when the cell [item type] says "PO" and the other column [PO #/CO #/Invoice #] does not contain the text PO. Here is my formula that is giving me a unparseable error. Any guesses on what i got wrong? I basically copied it from an existing formula in the sheet but my formula will not work.
=IF([Item Type]@row = “PO”, IF(NOT(CONTAINS(“PO”,[PO #/CO #/Invoice #]@row)),1,0),0)
Thanks!
Best Answer

=IF(AND([Item Type]@row = "PO", NOT(CONTAINS("PO", [PO #/CO #/Invoice #]@row))), 1, 0)
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers

=IF(AND([Item Type]@row = "PO", NOT(CONTAINS("PO", [PO #/CO #/Invoice #]@row))), 1, 0)
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

That worked, thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!