Subitem Due Dates Calculating so many days prior to the Parent Date

Hello,
We are utilizing monday to keep track of all our virtual events that we do and all that goes into them. These subtasks are re-occurring tasks for each event and each occur at different time intervals. The current solution we have is utilizing a formula to calculate the due date of the subitem so many days prior to the event date column in the subitems, however this does not allow that due date to appear as an actual due date for the folks who are assigned to the subtask, therefore not pulling the due date as a date so the task appears in their My Work. I really need to be able to have the calculated due date appear as a date so it shows up in everyone’s MyWork section. What is the best solution for this?

Hey there! If you’re still needing some guidance with this, please reach out to us at support@monday.com and we’d be happy to help you out!