I am trying to see if there is a formula that will look at the Cells in row 1, and if matched to the any of the weeks in column Week Of, will return the corresponding deliverable value in Column1. Attached is the clip of my smartsheet.
I tried the below formula given and it worked perfectly up until I looked at my sheet today and all my cells where the formula is are blank and I am not sure what changed from one day to the next and why it was working and now it doesn't.
Are there any other suggestions?
=IFERROR(JOIN(COLLECT([Column1]:[Column1], [Week Of]:[Week Of], @cell = "Oct Wk 1"), ", "), "")
Help Article Resources
Check out the Formula Handbook template!