Create new column with multiple conditions

This can't properly be checked without a a reprex (see the FAQ). There's no data to test with. (Also, RStudio is giving me conniptions over the long strings.)