I have a Board with a list of tasks and an automation set up to popular a column “Scheduled Task Date” which is calculated based on the “Project End date”, and the “weeks from the end date” to calculate the scheduled task date and format it as a date. Of the 13 tasks it has calculated them all correctly, with the exception of two. When I have 4 weeks from 26 December, for example, it is deducting 4 weeks rather than adding them on. (I have other tasks where I have put -4 and it calculates correctly 28 November but it is also calculating the same date for adding 4 weeks on"). I hope this makes sense and would appreciate some help!
Is the adjusted date a formula column or are you using automations to change that date?
Desiree - www.thecleverclovers.com
Morag Evans This behavior usually happens when the formula or automation is treating the weeks value as an absolute number rather than respecting the positive or negative sign consistently.
It sounds like the calculation logic may be defaulting to subtracting weeks from the Project End Date unless explicitly told otherwise, which is why both 4 and minus 4 are resulting in the same earlier date. I would recommend double checking the formula or automation rule to confirm how it handles positive versus negative values, particularly whether it is always subtracting the weeks field instead of adding when the value is positive.
If you are using a formula column, ensuring the calculation explicitly adds weeks when the value is positive should resolve this. Let me know what type of automation or formula you are using and I can help you fine tune it further.
Dr. Tanvi Sachar
Monday Certified Partner, Monday Wizard