IF(AND(NOT(ISBLANK Formula Trouble...

Hello all,

I'm having trouble nesting the IF(AND(NOT(ISBLANK formula.

If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column, I want the cell to say approved... this is what I have.

=IF(AND(NOT(ISBLANK([Provisional Requested Amount]@row)), [Provisional Requested Amount]@row <= [Final Requested Amount]@row, "Approved"))

Thanks in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!