Collect date on sheet 2 if tag on sheet 1 is contained within tag column on sheet 2


Hi, I'm stumped on a formula and hoping to get some help.

I have 2 sheets; Sheet 1 is titled E&I and contains the tag number and Sheet 2 is titled Open PO's and contains the date the item is due and the tag number with additional characters in a single cell. I am trying to pull in the date from the Open PO report into my E&I report if the tag number is contained within the column.

I've tried multiple formulas but this is what I currently have in Sheet 1: =IF(CONTAINS([Tag No]@row, {Open PO's Partno}), COLLECT({Open PO's Due Date}, {Open PO's Partno}, [Tag No]@row), "Received")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!