# IF/ OR

Hello, I am trying to create a formula that encompasses multiple dates. The current formula I have is as follows:

=IF(\$[In Date]5 = (\$[In Date]\$4 + [03-OCT]\$4), \$[Day Type In]5, IF(\$[Out Date]5 = (\$[In Date]\$4 + [03-OCT]\$4), \$[Day Type Out]5, IF(AND(\$[In Date]5 < (\$[In Date]\$4 + [03-OCT]\$4), \$[Out Date]5 > (\$[In Date]\$4 + [03-OCT]\$4)), "W", "°")))

I have added 4 more columns that I need to add to the in as a OR function.

In Date 2, Out Date 2, Day Type In 2, Day Type Out 2

Bit of a novice with this so any direction would be great!

Tags:

• Hi Nlila,

It might be helpful to take a screenshot of the sheet in question?

If I'm understanding the request, I wonder if the following will help...

=IF(OR(

\$[In Date]5 = (\$[In Date]\$4 + [03-OCT]\$4),

\$[In Date]5 = (\$[In Date]\$2 + [03-OCT]\$4),

\$[In Date]5 = (\$[Day Type In]\$2 + [03-OCT]\$4)),

\$[Day Type In]5,

IF(OR(

\$[Out Date]5 = (\$[In Date]\$4 + [03-OCT]\$4),

\$[Out Date]5 = (\$[In Date]\$2 + [03-OCT]\$4)

\$[Out Date]5 = (\$[Day Type In]\$2 + [03-OCT]\$4)

\$[Day Type Out]5,

IF(AND(\$[In Date]5 < (\$[In Date]\$4 + [03-OCT]\$4), \$[Out Date]5 > (\$[In Date]\$4 + [03-OCT]\$4)),

"W", "°")))

Hope this helps and that you have a great day,

Jason

• Thank you Jason. I tried that and it still being a little wonky. Here is a screenshot of the sheet.

Thank you!

• Thanks @NLILA

I may need to hand off to others in the community who may be able to help.

I'm not sure of the context, which cell you're putting the formula in or how to account for errors, sorry.

Hope this helps and that you have a great day,

Jason

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!