=[Date]@row + 7 is showing up as invalid column value


Hello Smartsheet Community!

Can someone please help me with this formula? I'm trying to calculate 7 days after my Date column, however the most common way stated in previous discussions I'm getting an #invalid column value. Please help!

Best Answer


  • Bellina Bui

    @Ben G THANK YOU BEN!!! It worked :D

    I can't believe I didn't think of this earlier.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!