Trying to incorporate ISBLANK into a formula

Bwoods113

=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

KPH

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