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

Options

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

Answers

  • Bellina Bui
    Options

    @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!