Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
8 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
------------------------------

2 Replies

Sort By
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    8 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
      8 months ago

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



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