I’m fairly new to IF statements, and looking to create a really simple IF statement by saying:
IF [collaborator = 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 .