Don't run formula if certain column value is 0 (zero)

Platform discussions Special workflows & use cases
1

I am successfully running a simple switch formula. SWITCH({Resume Advice}, “Yes”, 2, “Somewhat”, 1, “No”, 0, 0)
This tells me if my person received resume advice.
But I have another column called {Resume Goal}. If that goal is 0, I want the formula to return a zero even if they received resume advice. This way I’m not accounting for a goal met if they didn’t have that goal.
I tried this: SWITCH({Resume Advice}, “Yes”, 2, “Somewhat”, 1, “No”, 0, 0)IF({Resume Goal}>0) but it didn’t work.
How can I do this?

2

Hey @russellmidori ,

welcome to the community! :slight_smile:

You almost had it !

There you go:

IF({Resume Goal} > 0, SWITCH({Resume Advice}, "Yes", 2, "Somewhat", 1, "No", 0, 0), 0)

image

image

Greetings

3

Thanks so much TMNXT-Dev. I can’t tell you how grateful I am for your help. I think my math might still be off though. Would you like to talk more about this? russellmidori@gmail.com