Automate a response field

Cath Jones

I would like to automate a due date of 5 weeks from the creation date unless the status is “On Hold”. Then the date should be blank. When the status changes from “On Hold” to "Open" then the date can be recalculated as above. Unclear how this can be done.

ker9

@Cath Jones

Change the column names to match your column names. Add the formula to your Due Date column - ensure that it is setup as a Date column.

=IF([Status]@row = "Open", [Created]@row + 35, "")

This is giving you a date if status = Open, or blank for any other status.

Hope this help!