Returning a date


Good Morning!

I am having issues returning a date when I subtract a date (from a date column) from a number (text/number column). The column i am using the formula in is a date column.

My target finish column is generated by a formula based on target finish (Q). Would this affect the formula I am trying to use in Target Start?

The formula I am using is:

=[Target Finish (Date)]@row-[Project Start Days]@row

Any help is greatly appreciated as I am not sure why this formula is not correct.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!