Need help with formula IF PARENT, then INDEX/MATCH for Dupe Flag

First, thanks in advance for looking at my problem. I am sure I am making this more difficult than it has to be.

New: Release Update Sheet

  • Formula being added to this sheet in a Flag column
  • Based on IF Parent Row
  • This sheet has Parent AND Child rows
  • Initial field for INDEX/MATCH is Release Column

Release List

  • Duplicate (want to add this flag to the other sheet)
  • "Same" column on this sheet is called Releases
  • Desired return array is Duplicate? which is a Flag
  • Formula on this sheet for the flag: =IF(COUNTIF(Releases:Releases, Releases@row) > 1, 1, 0)

Since the formula resides on a sheet with both Parent/Child rows, I want a blank cell to appear on all child rows.

=IF([Is Parent]@row=1,INDEX({Duplicates}, MATCH(Release@row, {Releases}, 0)),"")

Sherry Fox

Project Analyst | Core Quality Services (QMS Transformation)


EAP | Mobilizer | Automagician | Superstar | Community Champion


Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!