IF OR Formula maybe Contains

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!

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!