Hi all, I am currently struggling with getting a formula created for the following scenario.
We are a DJ company, we assign a DJ to a lead by using the (DJ) status column. We then want to use a formula which obtains the DJ’s email address dependant on the DJ that is assigned so we can use the email for a calendar invite automation.
However, we have over 10 DJ’s and want to repeat this formula to pull the email address of the assigned DJ. What would be the correct way to format the ‘OR’ to continue to find the required value? Currently I have pasted the above formula again for each DJ, but this doesn’t work. I have also tried using a comma and also an OR, but maybe the format I have used is incorrect?
EDIT - Actually I noticed there was an issue with my formula as Monday.com wasn’t recognising one of the quotations, so that’s why I had to add some additional fields at the end to show the ‘No DJ Assigned’. Now I fixed the quotation, your solution works for the default value @GCavin