IF formula

Options

Hi

I'm trying to use an IF formula to return a TRUE or FALSE value if the value in column 1 (called Apr) is greater than the value in column 2 (called 2021 Actual) but struggling to do this.

=IF(Apr@row > [2021 Actual]@row, ''true'', ''false'')

Any help appreciated!

Tom

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!