Need help with #unparseable error in checkbox formula

VL0001
VL0001 ✭✭
in Formulas and Functions

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!

· Share on FacebookShare on Twitter

Best Answer

  • Mark.poole
    Mark.poole Community Champion
    edited 06/01/24 Answer βœ“

    @VL0001

    =IF(AND([Item Type]@row = "PO", NOT(CONTAINS("PO", [PO #/CO #/Invoice #]@row))), 1, 0)

    image.png

    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.

    · Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole Community Champion
    edited 06/01/24 Answer βœ“

    @VL0001

    =IF(AND([Item Type]@row = "PO", NOT(CONTAINS("PO", [PO #/CO #/Invoice #]@row))), 1, 0)

    image.png

    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.

    · Share on FacebookShare on Twitter
  • VL0001
    VL0001 ✭✭

    That worked, thanks!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!