Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
2 years 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","...
JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
2 years 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
    2 years ago

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



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