Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 18, 2019 01:46 PM
Hey guys,
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 .
Dec 18, 2019 01:54 PM
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