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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!