End Date minus x#of days =start date
Hello!
I am trying to enter a formula in a group of rows to have the end date -180days = start date column, but i've tried several different formulas and they all give me an error? Does the dependency to the parent row cause any issues for this - the sheet has 400+rows and i only need the formula in ~7 of them to equal the start date minus the end date = XX
Thank-you,
Best Answers
-
Try something along the lines of...
=[End Date]@row - 180
-
Are you getting an incorrect date, an error, or something else?
If you have dependencies turned on and referencing that column, you will not be able to use formulas. You would need to use the duration column.
Answers
-
Try something along the lines of...
=[End Date]@row - 180
-
Hello Paul,
Thanks for answering my question. I tried that entered in the "start date" column but what am i doing wrong - it's not calculating it from the end date?
-
Are you getting an incorrect date, an error, or something else?
If you have dependencies turned on and referencing that column, you will not be able to use formulas. You would need to use the duration column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!