20-09-24 09:51 AM
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
21-09-24 08:58 AM
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