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.

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @ldavenportHAP

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!