Vlookup or Index in a date column

I have read all the comments relating to the above, but nothing works for me. So I had to Link a cell, which means that if a row or column is added, I will have to amend the link.

I just wanted my Start date in a Gantt at Task@row to be able to look for this Task@row in another Gantt sheet and come back with the corresponding date. The function itself seems not to appear in the initial Date Column, when I "force" it, then there is no option to link an other sheet reference.

Please if you know for sure, could you let me know (how or impossible :))

Many thanks


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!