multiple choice answer options in google sheets

Matt_Round — Fri, 20 Sep 2024 08:51:50 GMT

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

Re: multiple choice answer options in google sheets

vrushalird — Sat, 21 Sep 2024 07:58:27 GMT

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

topic multiple choice answer options in google sheets in Product Forum

multiple choice answer options in google sheets

Re: multiple choice answer options in google sheets