If - Then - Else

saraha83081 ✭✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to create an If/Then/Else statement to determine if an employee is eligible for a pay increase.  Essentially, the formula needs to say 

IF Mandatory Training Requirements Met = YES

AND Corrective Action = NO

THEN Eligible for Increase = YES

ELSE Eligible for Increase = No

Any thoughts on how to accomplish this?



SmartSheet Sample.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!