BuildPro
12 months agoQrew Captain
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
------------------------------