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","...
Forum Discussion
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
------------------------------
Thank you...I had to add ToText to make it work, tho.
------------------------------
BuildPro
------------------------------
