I have one date, call it A, that moves through multiple boards and is linked to a calendar, so when it’s moved on the calendar, the date changes on the boards and vice versa. I would like another date on the same boards, B, that is the A date plus a certain amount of working days depending on a dropdown box.
For example when a new item is created, A is set to 5th June 24, the dropdown is 5 Working Days. This then automatically sets B to the 12th June 24. if then on the calendar I move the item to the 9th July 24, then B should auto move to the 16th July.
Any help would be greatly appreciate, Thanks
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
2
Hi Michael,
Did you try a formula column? Create a formula column and use this syntax:
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.
Hi, You can use formulas or automations to calculate the date for column B based on the date in column A and the selected number of working days from the dropdown box.