Need help with "if" formula

brandon Calvert

help!

I would like my "outside lead time" column to populate a number when different options are chosen in my "outside process" column. Example, if passivate is chosen then i want outside lead time to populate "5",

ideally if 2 items are chosen in outside process it would add the 2 values in "outside lead time example "passivate" and "edm" both have "5" as values then outside lead time would read 10.

Matt Lynn-PCG

@brandon Calvert something like…

=if(contains("passivate",[outside process]@row),5,0)+if(contains("edm",[outside process]@row),5,0)