add a day to entire project
with different due dates.. adding a day to one task will move all dates in project out... how to I do this withough manually having to enter each new date?
Best Answer
-
Hi @jvalchine
You can add a day to a Date by using + 1
=[Date Column]@row + 1
See: Use Formulas to Perform Calculations With Dates
However I'm not sure I understand what it is you're looking to do. Are you just looking to add a new task to a Project sheet without adjusting all the current tasks? In this case, you'll just need to make sure you don't add any Predecessors to that row.
If this hasn't helped, it would be useful to see a screen capture of your sheet, but please block out sensitive data.
Cheers,
Genevieve
Answers
-
Make a new column for the new date.
enter this formula where the original date column is date@row:
=DATE(YEAR(Date@row), MONTH(Date@row), DAY(Date@row) + 1)
-
okay christian I entered the following as you stated and nothing worked..:
date@row:=DATE(YEAR(Date@row), MONTH(Date@row), DAY(Date@row) + 1)
-
did I enter the formula correctly?
-
Hi @jvalchine
You can add a day to a Date by using + 1
=[Date Column]@row + 1
See: Use Formulas to Perform Calculations With Dates
However I'm not sure I understand what it is you're looking to do. Are you just looking to add a new task to a Project sheet without adjusting all the current tasks? In this case, you'll just need to make sure you don't add any Predecessors to that row.
If this hasn't helped, it would be useful to see a screen capture of your sheet, but please block out sensitive data.
Cheers,
Genevieve
-
genevive i do not understand predecessors. can you give me a clifnotes on when you use them and for what purpose? I am new to this and learning!!
-
by adding a day to one of the tasks .. I want it to automatically add a day to all the tasks including the complion date of the project. this way i wont have to reenter every date for every task.. does this make sense? can support help me ?
-
Hi @jvalchine
Predecessors link your tasks together. You add the row number that your current task is dependent on, and then that way if you change the date of an earlier task it will automatically push out any tasks that are dependent on it!
Here's a Help Article that goes through Predecessors: Enable Dependencies and Use Predecessors
If you're new, you may want to watch this free Webinar on Project Settings that talks about task relationships: SmartStart: Project Management
Cheers,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives