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.




Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!