Invalid column value

Hello, I am trying to reuse a formula I have used in the past and i keep getting the error "INVALID COLUMN VALUE".

The formula is: =[DR Plan Start Date - WKSTRM POPULATES]@row + INT(INT([Duration (DO NOT UPDATE)]@row) / 24)

I confirmed the cells is reading from are date cells and a text number cell. What other reasons could be causing this?

Best Answer


  • Thank you! This resolved the issue perfectly!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!