Date Calculations
Hey y'all super new to this, I am trying to have the goal date be based on the Target open date less the days prior. The formula I have is " =Description1 + [Days Prior to Opening]@row " which returns the above.
What am I doing wrong and how to do I fix it? Dependencies are turned off.
Best Answer
-
Description needs to be set as a date type column. So does Goal Date.
Answers
-
Description needs to be set as a date type column. So does Goal Date.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!