set reminder for time in diffrent row
hi
how can i set a reminder to task (b) for 2weeks prier ro after date of taks (a) ?
so in i change task a date task b will change too
Best Answer
-
Hi @elad
I agree with @Mike TV! You could use a formula in Task B's cell to add days to Task A's date and bring that back into the current row. Here's an example:
See: Use Formulas to Perform Calculations With Dates
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Just create a column for a reminder date with Task A date +14. Make sure the new column is a date type column.
-
if row1 is start project day and row 2 is a meeting after 12 days and i change row 1 date how will row 2 change accordingly ?
-
Hi @elad
I agree with @Mike TV! You could use a formula in Task B's cell to add days to Task A's date and bring that back into the current row. Here's an example:
See: Use Formulas to Perform Calculations With Dates
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
thank :)
why the formula don't work on stat & end day column?
-
Hi @elad
Are you using Project Settings in this sheet?
Here's more information: Areas where formula use is restricted
The following fields being used for dependencies and resource management:
Start Date
End Date
Duration
Predecessors
% Complete
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
not sure i understand how the settings works. now the start date work and due date don't with the formula
-
Hi @elad
Thank you for this screen capture!
The reason you cannot add a formula to your Due Date column or End Date column is because you are using this with Dependencies.
What this means is that instead of adding a formula to one of your dates, your dates will automatically calculate if you add a Duration (number of days) into the duration column.
For example, if you add a date in your Due Date column, then add "12" into your Duration column, the End Date date value will automatically return a date that's 12 working days later.
See this free webinar with more information:
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives