IF OR Formula maybe Contains

AC20402

Multiple job types produce the same number of days. I want to simply the formula without having to write each type out but I keep getting errors. I know this works for just one but how can I rewrite for the formula to be IF its this job type or that job type or that job type = this number of days. Not sure if I should be using a Contains function instead.

=IF([Job/Construction Type]@row = "ResidentialLineExtension - SDU Residential Serviceability", "48")

Thank you!

Heather Duff

Hi @AC20402 ,

You may want to consider using the INDEX/MATCH combo. Here's a good post about it: https://community.smartsheet.com/discussion/36341/index-and-match

Basically, you can create a sheet as your index, and you can use a formula to look up the days based on the type. For example, if my index sheet had a Days and Type column, here's what my formula in the Total P2 to Activate column in the destination sheet would look like:

=INDEX({days range from index sheet},MATCH([job/construction type]@row,{type range from index sheet},0)

Hope this helps!

Best,

Heather

Heather Duff

Hi @AC20402 ,

You may want to consider using the INDEX/MATCH combo. Here's a good post about it: https://community.smartsheet.com/discussion/36341/index-and-match

Basically, you can create a sheet as your index, and you can use a formula to look up the days based on the type. For example, if my index sheet had a Days and Type column, here's what my formula in the Total P2 to Activate column in the destination sheet would look like:

=INDEX({days range from index sheet},MATCH([job/construction type]@row,{type range from index sheet},0)

Hope this helps!

Best,

Heather

AC20402

Thank you Heather! I looked into this and found VLOOKUP as well. I appreciate you leading me in the right direction.

Heather Duff

Happy to help! I definitely recommend using INDEX/MATCH over VLOOKUP.