CONTAINS formula

Question

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------------------------------

SSNJeffP · Answer

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------------------------------

Sign up

Login to the community