Trying to incorporate ISBLANK into a 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),)
Getting an unparseable on this one any help would be greatly appreciated.
Brandon
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!