# If Blank formula help

=IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down"))

I want to add if "Accounts Per Day w/o TOOQL" @ Row is blank, leave blank or sideways arrow is fine if i have to choose something.

• Sorry, here's the working one:

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row)), IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down", "")))

• Try this:

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row)), IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down"), ""))

• i am getting incorrect augment set with this..

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row), "", =IF(OR(Level@row = "", [Accounts Per Day w TOOQL]@row = ""), "", IF([Accounts Per Day w TOOQL]@row < Level@row, "No", "Yes"))))

• Try this:

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row)), IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down"), ""))

• @Mike TV i am still getting "This column formula syntax isn't quite right" with that :(

• Sorry, here's the working one:

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row)), IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down", "")))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!