how to write if column (a list) contains x then 1 else 0

Options
Jessv
Jessv Member, ALL USERS Posts: 4 New Contributor
in Planning & Modeling

Hi there - 

am new to anaplan have only used excel extensively. I need to add a conditional colum (col 2)n based on another column (col1) which is a list type. That is if col1 contains "x1" or "x2" then 1 else 0. 

Thank you

Tagged:

Comments

  • Jessv
    Jessv Member, ALL USERS Posts: 4 New Contributor

     

    Hi im trying to update the success criteria actual column = if status is "Achieved" or "On Track" then 1 else 0?

  • Jessv
    Jessv Member, ALL USERS Posts: 4 New Contributor
    status col is populated from a list
  • Jessv
    Jessv Member, ALL USERS Posts: 4 New Contributor
    Thank you very much Tiffany that worked!!

Categories