A new knowledge base article has been published on our support portal.
In this scenario we wish to automatically create follow up tasks whenever a task is completed. We will need to be able to dictate how far into the future the follow up task should be and the follow up task can only be due to be completed on working days.
Note: For this formula you will need to create and add 3 custom fields on the Task entity and form - new_original_scheduledend (of type Date time), new_recurringtype (of type Boolean) and new_recurringtask (of type Option Set as shown below – you may need to match these up to the formula if your Option Set differs)
N52 Formula Manager Solution
The Formula Manager solution works like this:
- We create a formula to trigger whenever a Task is set to complete
- Once the formula has been triggered, it will check to make sure the Task is a recurring task
- If it is, the formula will calculate the Due Date of the follow up Task using the Original Scheduled Date and the Recurring Type selected on the form
- The formula will then check to see if this Due Date is a working date and it will move the Due Date onto a working day if needed