Hello! I'm having an issue in building a formula to trigger an approval request. Here are my 3 columns: [Current Pay], [New Pay], [Pay Increase].

Here's the scenario:

IF the New Pay field is not blank, not equal to NA, AND greater than the number in the Current Pay field, the Pay Increase field should equal TRUE.

Can anyone assist?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!