Skip to main content

Hey guys,


I’m fairly new to IF statements, and looking to create a really simple IF statement by saying:


IF Fcollaborator = Meg], show “Design”


I have a column of “Collaborators” (Meg, Rob, Sarah, David, Josh) and a column of departments (Design, Analytics, Research, Strategy, Development). If Meg is selected as a collaborator, show design in the department column, if rob is selected in collaborator column, show analytics in the department column … etc …


Any help would be greatly appreciated .

Hi @David_Mannheim - you could use an IF() statement, although a better choice in this case (as it isn’t “many-nested” and, therefore, more complicated to write) is a SWITCH() statement:


SWITCH(

  Collaborator, 

  'Jonathan Bowen', 'Marketing', 

  'Jane Jones', 'Sales',

  ...

)

This is saying: Evaluate the “Collaborator” field; if it equals “Jonathan Bowen”, then return “Marketing”; if it equals “Jane Jones”, then return “Sales” and so on.



JB

Reply


Terms & Conditions