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
