Help with if

Sue van Niekerk

=IF([Function Type]@row = "ops", NAME@row), =IF([Function Type]@row = "Office", NAME@row) , ""))

Hi All,

What have I done wrong in my IF formula - gives me a UNPAREABLE error

Kelly Moore

Hey @Sue van Niekerk

The IF statement above is closed off too early with parentheses. Try this.

=IF(OR([Function Type]@row = "ops", [Function Type]@row = "Office"), NAME@row)

I added an OR statement since both of the IFs resulted in the same outcome.

If interested, you can find more information below.

Will the formula work for you?

Kelly

https://help.smartsheet.com/function/or

https://help.smartsheet.com/function/if