Conditional Column

[Jakuza]

Hi, I'm trying to create a conditonal column and not sure how to do it properly.

For example, I have two columns, one is called OU and the other is called Office. The OU column has values that say "Computers" where as the column "Office" has the value that I want to display, is there any way that I can do somethingl ike:

If Column "OU" value equals "Computers" then "Office" value replaces that?

|     NAME       |       OU      |     Office    |
| Computer 1  | Computers| Austin, TX |
| Computer 2  | Dev Server|      Root     |

[Anonymous]

Hi @Jakuza,

Try creating a new column using an IF condition

IF(Table(OU) = "Computers", Table(Office), [else...])

Are there multiple conditions like "Computers"? If the value is not "Computers", what would you like to display as Office?

[Jakuza]

The idea is that if it displays something other than "Computers", the value should not change.

[Anonymous · Accepted solution]

Then try

IF(Table(OU) = "Computers", Table(Office), Table(OU))

Does this help?

[Jakuza]

Thank you!