Hello! I have a “completion date” column for items on my board. When the completion date + 30 days = today, I want the item to move to another board. I have used the formula field to give me a “move date” but I can’t figure out how to move the item to the other board automatically.
The formula I am using for the move date is ADD_DAYS({Completion Date},30).
Is it possible to add to the formula something like: IF (ADD_DAYS({Completion Date},30)=today move item to “other board”
I could do that easily if the column I am trying to compare were a date, but it shows up as a formula field and so is not viewable as a date if I try to make a date automation.
I’ve looked through the FAQs but couldn’t find a question like this one.
When DATE arrives (you select any number of days before or after) move item to board
Edit:
Apologies I have just seen you are not using a date column, but a formula derived date.
That’s the limitation of formula’s I’m afraid, they cant be used in automations or integrations, I have no idea why it seems a massive shortfall to me.
Have you considered moving away from formula?
Could this be achieved by this recipe:
When item is created set completion date to creation date plus 30 days
When item is created set move date to creation date plus 60 days
When move date arrives move item to board
Thank you for your response! When I try to create that, I am not able to add 30 or 60 days. I only have the option to set something to today. Am I missing something?
edit: I figured it out… I need to use push date instead of set date. thanks again!
I spoke too soon! I can get the start date to set when I create an item. when I try to push a date to another column that date does not show up in the new column at all.
I am using this
When ‘completion date’ arrives push ‘move date’ by 30 days
I did a test with some new items and added completion dates of today and yesterday just to check but the move date does not get populated.
I’m really getting frustrated. Why does everything have to be so convoluted?
I’ve also tried when “project status” changes to “done” set move date to today + 30 days.
“Project status” sets completion date to ‘today’ and that works fine. I am having issues with anything that is not today.