Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Using an OR() Formula

Topic Labels: Formulas
Solved
Jump to Solution
1174 2
cancel
Showing results for 
Search instead for 
Did you mean: 
gemisic
4 - Data Explorer
4 - Data Explorer

Hello,

I'm a beginner when it comes to using formulas. This is my first time using a formula with conditions. Im looking to display a message when employee's reach our milestone years of service to the company. I know Im close, but its not working. Can someone tell me what am I doing wrong here? Here is my formula:

IF(
  OR(
    {Working Years} = 1
    {Working Years} = 3
    {Working Years} = 5
    {Working Years} = 7
    {Working Years} = 10
  ),
  "🎉 Announce on Social Media")
1 Solution

Accepted Solutions
pressGO_design
10 - Mercury
10 - Mercury

You need commas between your working years inside your OR statement. 

OR(
    {Working Years} = 1, 
    {Working Years} = 3,
    {Working Years} = 5,
    {Working Years} = 7,
    {Working Years} = 10
  ),

See Solution in Thread

2 Replies 2
pressGO_design
10 - Mercury
10 - Mercury

You need commas between your working years inside your OR statement. 

OR(
    {Working Years} = 1, 
    {Working Years} = 3,
    {Working Years} = 5,
    {Working Years} = 7,
    {Working Years} = 10
  ),

Ahhh yes! (duh)

It worked! Thank you very much. ðŸ˜ƒ