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
Check out the Formula Handbook template!