How to set due date based on start date

[HCF]

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?

[takuya_miyai]

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())

[Steve · Accepted solution]

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]))
)

[HCF]

Steve:

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

Perfect - thank you @Steve