Creating a 2nd date calculated from initial date

edited 12/09/19 in Formulas and Functions

Added data in row with a created date I want to automate an expected close date 30 days from created date.However the expected close date could move and I want to be able to change that days adding on days until actual becomes yesterday.

of this I want to run forcasting into months  and length of sell cycle.

I have read that the first part works with =[Created Date] +30      , but I have not been able to make that formula give any outcome except errors and I have tried a number of variations based on comments in help and community.

I feel if I can crack this I can then at least move on to the next issue.

Any suggestions 




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!