=IF(AND(HELP!

jess_roberts

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?

jess_roberts

I figured it out! Never mind!

Genevieve P.

Hey @jess_roberts

I'm glad to hear you figured it out! If anyone else is looking for a similar formula, here's an example of the structure:

=IF(AND([New Pay]@row <> "", [New Pay]@row <> "NA", [New Pay]@row > [Current Pay]@row), 1, 0)

Cheers,

Genevieve