cancel
Showing results for 
Search instead for 
Did you mean: 

multiple choice answer options in google sheets

Matt_Round
Level 3

I have a process for HR reminder emails for new starters that uses google sheets and collects the data as a collection, one cell im using is for application status (i.e Indeed, Jobmarket, Internal Move, Promotion etc).

I dont need to send emails to internal vacancies only external applications, im struggling with a calculation that will look at the cell in question and give the answer if it includes one of the internal options. 

the calculation ive tried is as follows: [Cell values.Column 27]="Internal Move" OR "Promotion" OR "Demotion" OR "Secondment" OR "Acquisition"

I get the error "Both operands for 'OR' must be a flag" is there a way i can have all the above options in one calculation stage?

 

Thanks

 

1 REPLY 1

vrushalird
Level 3

Hi Matt,

It seems like you want to compare the values in Column 27 with either "Internal Move," "Promotion," "Demotion," "Secondment," or "Acquisition." In that case, the condition should be written as follows:

[Cell values.Column 27] = "Internal Move" OR [Cell values.Column 27] = "Promotion" OR [Cell values.Column 27] = "Demotion" OR [Cell values.Column 27] = "Secondment" OR [Cell values.Column 27] = "Acquisition"

I hope this helps!

Thanks,
Vrushali