Date pulled via VLOOKUP from another sheet not recognized as date?

I have a column that is of date type. In that column, I'm pulling a date into a cell from another sheet using VLOOKUP. So, the cell displays a date, but the cell content is a formula. I'd like to use that displayed date in another cell inside a formula, but I get an #INVALID OPERATION error. It appears that Smartsheet can only see the formula, not the displayed value. Is there a way around this? Thanks in advance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!