I want to know if what I want to do exist on Monday.
This automation below:
When ( status ) changes to something, set ( due date ) to current date plus ( some days )
I would like to know if it is possible to make ( some days ) as a variable that refers to another column?
Example: When status changes to something, set due date to current date plus some days that are in another column on the same row
thx for helping
Hi Benoit,
This does not exist unfortunately. However, you can use a workaround.
Use a technical column called “date reducer” EDIT: to clarify, this should be a status column.
When status changes, change Date Reducer to Reduce
When Date Reducer changes to Reduce
And only if Number is greater than 0Reduce Number by 1
Push date by 1 day
Set Date Reducer to Ready
Set Date Reducer to Reduce
This will loop and keep reducing the count until it has pushed that number of days, but it’ll cost you an automation each time.
If you’re planning to use larger numbers, you could scale this up and combine so that it does something like push in 10s or 7s (or higher) and then try to push by 1s.
Let me know if you need help with that.
The alternative to this would be using some kind of app or integration like General Caster or make.com.
EDIT: it would probably be better to label the column “Date Pusher” and use a “Push” status. Nevertheless, this is a guide for functionality.
thank you so much Francis !!