Vlookup - copy a date to another sheet



I would like to use a vlookup to copy a due date to another sheet. The vlookup works in other cases, just with the date it doesn't and I get #INVALID COLUMN VALUE as a result. I know it has to do with the date itself but I am unable to figure this out myself :-) - can someone help?

The formula:

=IFERROR(VLOOKUP(([name]@row + group@row + "release"); {Produktion Bereich 2}; 9; false); "")

the date format ist German, so DD.MM.JJJJ

Thanks a lot in advance :-).


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!