Calculate a deadline date in a column

Hi. I’m looking to do something that should be (and therefore hopefully is) very simple. When an item is created on a board it sets a date column with a “received date” of today(). Currently I have a “Due date” which is a formula based on using ADDDAYS to set a date x days in the future. However, this is entirely useless as it transpires a date in a formula column can’t be used for pretty much anything.

Is there a way to create a workflow or similar such that when the item is created and the Received Date is set, the Due Date is then updated to Received Date + x days?

I’ve looked at dependency columns but this doesn’t seem to do what I need. Any advice welcomed.

Yep! You’ll need to do an automation of ‘when item created, set due date to today and then push date by x days’

Desiree - www.thecleverclovers.com

1 Like