Trying to incorporate ISBLANK into a formula

Options

=IF(ISBLANK([Monday Job]@row, ""), INDEX(COLLECT({Per Diem Database Range 1}, {Per Diem Database Range 2}, [Employee ID]@row, {Per Diem Database Range 3}, [Monday Job]@row), 1),)


Getting an unparseable on this one any help would be greatly appreciated.

Brandon

Tags:

Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    Hi @Bwoods113

    You're nearly there!

    At the start of the formula move the "" that you want to appear if Monday Job is blank to outside of the ISBLANK parenthesis. This then puts "" as the result if ISBLANK([Monday Job]@row) is true.

    Change

    =IF(ISBLANK([Monday Job]@row, "")

    to

    =IF(ISBLANK([Monday Job]@row), "",


    Then at the end, remove the comma before the last parenthesis

    Change

    , 1),)

    to

    , 1))


    Final formula

    =IF(ISBLANK([Monday Job]@row), "", INDEX(COLLECT({Per Diem Database Range 1}, {Per Diem Database Range 2}, [Employee ID]@row, {Per Diem Database Range 3}, [Monday Job]@row), 1))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!