Add New Column

[HenryJS]

Hi all,

Whats the quickest way to add a new column that states IF = 'DocumentName' THEN 'New Document Name'

for example IF 'PASSPORT' THEN 'RTW'?

Thanks

[az38]

@HenryJS 

try to use switch()

New Column = SWITCH(Table[DocumentName],
"PASSPORT", "RTW",
"BIOMETRIC_PERMIT", "RTW",
Table[DocumentName]
)

[amitchandak · Accepted solution]

Try like

New Document Name = IF([DocumentName] ="PASSPORT","RTW",[DocumentName])

Or
New Document Name = switch(true(), 
[DocumentName] ="PASSPORT","RTW",
//Add more
[DocumentName])