Feb 01, 2024 12:44 PM
I'm using airtable to manage all my seasonal employee hiring. I have one column where from a multiple selection I choose their job title (eg. Camp Ops, Kitchen, or Waterfront). I want another column that show what certification are required based on the job title I selected. I believe this should be a IF or SWITCH formula.
Currently I have a working formula that is
Feb 02, 2024 06:11 AM
you have a lot of options in the select field, so you should use the SWITch formula.
here is the support link: https://support.airtable.com/docs/an-alternative-to-if-statements-using-switch
in your case you should code like this:
SWITCH(
{JOB},-------THIS IS YOUR SINGLE SELECT FILED NAME
'WATERFRONT','THIS REQUIERES TO BE SUPERMAN',
'COOKING','BEST CHEFF DEGREE',
[....],
'CHECK THE JOB LIST'-------(THIS LAST OPTION IS IN CASE THE FORMULA CAN'T FIND THE OPION IN THE LIST)
)---END
Feb 02, 2024 11:30 PM
As @Marcelo said, a SWITCH is probably your best bet. For future reference, you can also chain up your IF's with an '&' like so:
IF(Job='Kitchen',"First Aid & CPR) &
IF(Job='Waterfront',"Lifegaurding")
If you find that you have a lot of jobs and certifications and don't want to handle them all via formula field, perhaps you could also consider creating a "Jobs" table and putting every job and certification in there, then using a linked field with a lookup field like so: