INDEX MATCH Formula to return TEXT value if formula value is BLANK

Filippo ✭✭
edited 03/01/23 in Formulas and Functions

Hello! I am using an INDEX / MATCH formula to return values from a different sheet. I would like the formula to return the TEXT "Pending" if the value from the formula is BLANK.

This is the formula that i have, which works fine. I just need to build in the =ISBLANK statement, to return "Pending"


=IFERROR(INDEX({Site Onboarding - Privacy Practice Notices}, MATCH([Site Name]@row, {Site Onboarding - Site Name}, 0)), "")

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!