How to set due date based on start date

Is there a way to set the value of my [Due Date] when the value of [Start Date] is updated so that the [Due Date] will be either Today() or [Start Date] if the [Start Date] is in the future?

Hi @HCF

The [Due Date] should be editable afterwards, right?

In that case, I think you will have to use Automation.

Events

Capture the update of [Start Date].


[_THISROW_BEFORE].[StartDate]<>[_THISROW_AFTER].[StartDate]

Task

Update the value of [Due Date] according to the updated value of [Start Date].


IF([_THISROW_AFTER].[StartDate]>TODAY(),
[_THISROW_AFTER].[StartDate],
TODAY())
1 Like

For the Due Date column, set Reset on edit? to this expression:

AND(
  ISNOTBLANK([_THISROW_AFTER].[Start Date]),
  ([_THISROW_AFTER].[Start Date] <> [_THISROW_BEFORE].[Start Date])
)

And set its Initial value to this expression:

IFS(
  ISNOTBLANK([Start Date]),
    MAX(LIST(TODAY(), [Start Date], [Due Date]))
)
3 Likes

Perfect - thank you @Steve

2 Likes