# If Blank formula help

Options
✭✭✭✭

=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.

• ✭✭✭✭✭✭
Options

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", "")))

• ✭✭✭✭✭✭
edited 06/03/22
Options

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"), ""))

• ✭✭✭✭
Options

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"))))

• ✭✭✭✭✭✭
Options

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"), ""))

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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", "")))

• ✭✭✭✭
Options

@Mike TV Thank you!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!