Need to check a box if any of these are true

deb_63_hydracor

Hi,

I'm trying to check a box if Sales Status equals either "Deployment Prep Call - Scheduling", "Deployment Prep Call - Scheduled" or "Verbal Agreement"

The formula works for one of the three choices:

=IF([Sales Status]@row = "Verbal Agreement", 1)

However, I'm getting an INVALID DATA TYPE error when I have all three choices in my formula:

=IF([Sales Status]@row, OR(@cell = "Deployment Prep Call - Scheduling", @cell = "Deployment Prep Call - Scheduled", @cell = "Verbal Agreement", 1))

Thanks for your help!

Andrée Starå

Hi @deb_63_hydracor

I hope you're well and safe!

Try something like this.

=IF(OR([Sales Status]@row = "Deployment Prep Call - Scheduling", [Sales Stat]@row = "Deployment Prep Call - Scheduled", [Sales Stat]@row = "Verbal Agreement"), 1)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!