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. Does anyone know if there is a formula that can do this? I have tried using IF, INDEX, MATCH, and have had no luck.
I tried the below formula given to me and think it is close, but the cells show up as blank when I entered the formula in it. However it looked like it worked for the person who gave this to me, so I am not sure what I am doing wrong. Are there any other suggestions?
=IFERROR(JOIN(COLLECT([Column1]:[Column1], [Week Of]:[Week Of], @cell = "Aug Wk1")), "")
Here are some screenshots from my sheet for reference.
Help Article Resources
Check out the Formula Handbook template!