project date 6 weeks from another date on a row
How do I write a formula to project out 6 weeks from another date on that row?
Answers
-
You can just add days to the source dates.
=[Date Column]@row +42 would add 6 weeks
-
Doesn't work
-
Ok, now I have it, thanks. Also, how do I do that as a column function
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!