set reminder for time in diffrent row

elad · 11/30/22

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

Genevieve P. · 12/06/22

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

Mike TV · 12/01/22

@elad

Just create a column for a reminder date with Task A date +14. Make sure the new column is a date type column.

elad · 12/04/22

https://community.smartsheet.com/discussion/comment/352882#Comment_352882

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 ?

Genevieve P. · 12/06/22

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

elad · 12/08/22

https://community.smartsheet.com/discussion/comment/353267#Comment_353267

thank :)

why the formula don't work on stat & end day column?

Genevieve P. · 12/08/22

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

elad · 12/10/22

https://community.smartsheet.com/discussion/comment/353614#Comment_353614

not sure i understand how the settings works. now the start date work and due date don't with the formula

Genevieve P. · 12/12/22

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:

https://help.smartsheet.com/learning-track/onboarding-webinars/smartstart-project-management

set reminder for time in diffrent row

Best Answer

Answers

Categories