Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
12 months ago

CONTAINS formula

How do I easily change this formula from [Task Phase] = "xxx", "000"

to

[Task Phase] contains

If(
[Task Phase]="Office-Start","000",
[Task Phase]="Pre-Start","001",
[Task Phase]="Pre-Hang","002",
[Task Phase]="Drywall","01")



------------------------------
BuildPro
------------------------------
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    12 months ago

    If(

    Contains([Task Phase],"Office-Start"),"000",
    Contains([Task Phase],"Pre-Start"),"001",
    Contains([Task Phase],"Pre-Hang"),"002",
    Contains([Task Phase],"Drywall"),"01"
    )



    ------------------------------
    Jeff Peterson
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      12 months ago

      Thank you...I had to add ToText to make it work, tho.



      ------------------------------
      BuildPro
      ------------------------------