Hi,

I’m really struggling with a formula for the following scenario, please can someone help.

I have the following ‘Assignment Types’

Short Term Assignment 

Commuter Arrangement (2015)

I need a formula to look at the text in a field and if it matches either of these Assignment Types it shows ‘Home’, if it doesn’t match, it shows ‘Host’.

I may need to add further Assignment Types later so I also need to know how to add in further text options to look for to show a result of Home.

@Sergei Baklan I’ve read a similar one that you helped with. Would appreciate any help!

Jo

​Hi, I’m really struggling with a formula for the following scenario, please can someone help. I have the following ‘Assignment Types’ Short Term Assignment Commuter Arrangement (2015) I need a formula to look at the text in a field and if it matches either of these Assignment Types it shows ‘Home’, if it doesn’t match, it shows ‘Host’. I may need to add further Assignment Types later so I also need to know how to add in further text options to look for to show a result of Home. @Sergei Baklan I’ve read a similar one that you helped with. Would appreciate any help! Jo  Read More

​