Formula Help trying to combine IFERROR with reference and a "then"

Im trying to amend this formula.

The formula (below) works and references a cell in another sheet and displays the color ball entered in that sheet.

=IFERROR(INDEX({CS - Health}, MATCH([Project Key]@row, {CS - Project Key}, 0)), "")

I want to add a condition that says if the reference cell in the other sheet is empty, my sheet should display a "Gray" ball

OR another option would be that if the % Complete column (to the left in row) is =0% the ball is gray

Find more posts tagged with

Accepted answers

All comments

Jason Tarpinian

=IFERROR(IF(INDEX({CS - Health}, MATCH([Project Key]@row, {CS - Project Key}, 0))="","Gray",INDEX({CS - Health}, MATCH([Project Key]@row, {CS - Project Key}, 0)), "")

I'm just free-styling it, so I might've missed a comma or parenthesis. But basically what you want to do is say that IF <input your index/match formula> = "" then show "Gray", otherwise do the normal formula, if error show blank.

Kym

oooh thank you - let me try that.

Kym

seems to work but may be false positive, will keep noodling but thank you

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.