What can I add to return a blank if the cell referencing is blank?
I have a formula that pulls in some information from another sheet. =INDEX({Function}, MATCH([Support Manager (email)]@row, {Assigned}, 0)). The formula works fine except that I want it to return a blank if the "Support Manager (email)" is blank. Unfortunately the "Assigned" columns in the sheet it is referencing has blanks so my formula grabs the first blank in the reference file and gives me an answer. I want it to show "Support Manager Organization" as blank if the "Support Manager (email) is blank.
Thanks.
Amy
Best Answer
-
Hi @Amy Bedard ,
You could do something like this:
=IF(ISBLANK([support manager (email)]@row),"",
and then insert your INDEX formula.
This translates to "if the support manager email column in this row is blank, show blank. Otherwise, run the INDEX formula.
Hope this helps! Let me know if it works for you.
Best,
Heather
Answers
-
Hi @Amy Bedard ,
You could do something like this:
=IF(ISBLANK([support manager (email)]@row),"",
and then insert your INDEX formula.
This translates to "if the support manager email column in this row is blank, show blank. Otherwise, run the INDEX formula.
Hope this helps! Let me know if it works for you.
Best,
Heather
-
Yes. That worked. Thank you.
-
Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!