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
-
Genevieve P. Employee AdminYou 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
-
Christian Graf ✭✭✭✭✭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?
-
Genevieve P. Employee Admin
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 ?
-
Genevieve P. Employee Admin
Predecessors link your tasks together. You add therow numberthat 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
First, do a list of all of the groups, find the groups and their IDs, and then create a request to add your user to the respective group.<\/p>
Ryan<\/p>
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User Management"}]},{"discussionID":110515,"type":"question","name":"How do I add text to a formula","excerpt":"My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25% =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) Thanks.","snippet":"My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25%…","categoryID":321,"dateInserted":"2023-09-20T16:52:32+00:00","dateUpdated":null,"dateLastComment":"2023-09-20T17:33:32+00:00","insertUserID":159073,"insertUser":{"userID":159073,"name":"SJTA","url":"https:\/\/community.smartsheet.com\/profile\/SJTA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-23T18:47:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159073,"lastUser":{"userID":159073,"name":"SJTA","url":"https:\/\/community.smartsheet.com\/profile\/SJTA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-23T18:47:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":48,"score":null,"hot":3390461164,"url":"https:\/\/community.smartsheet.com\/discussion\/110515\/how-do-i-add-text-to-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110515\/how-do-i-add-text-to-a-formula","format":"Rich","tagIDs":[219,254],"lastPost":{"discussionID":110515,"commentID":396248,"name":"Re: How do I add text to a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396248#Comment_396248","dateInserted":"2023-09-20T17:33:32+00:00","insertUserID":159073,"insertUser":{"userID":159073,"name":"SJTA","url":"https:\/\/community.smartsheet.com\/profile\/SJTA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-23T18:47:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-20T17:32:18+00:00","dateAnswered":"2023-09-20T17:27:12+00:00","acceptedAnswers":[{"commentID":396247,"body":" Just add the text you want in quotes, than a plus sign, than the formula text.<\/p> =\"Milestone 1 - \" + INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) <\/p> Or...<\/p> =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) + \" - Milestone 1\"<\/p> You can see an explanation of a similar use case in this video https:\/\/youtu.be\/g9eap8EjFTI?t=272<\/a><\/p> Dan Palenchar | <\/strong>School of Sheets Solutions Consulting<\/a> (Smartsheet Aligned Gold Partner)<\/p> Smartsheet Consulting Inquiries: schoolofsheets.com\/workwithus<\/a><\/p> Smartsheet Tutorial Videos: schoolofsheets.com\/youtube<\/a><\/p>
![\"Email](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/YLZSWDRJUALA\/email-signature-logo.png\"){kind=logo}
<\/img><\/a>\n <\/div>\n<\/div>\n
