Loading...
Quick Links

Reply To: Adjust my Formula to show tasks that start the following week

Home Forums Discussion Adjust my Formula to show tasks that start the following week Reply To: Adjust my Formula to show tasks that start the following week

#328144

Instead of a formula, I would apply a custom group to Start column to group the start dates on weekly basis, starting from the status date. Anyway, the following formula may work (tasks scheduled to start between [Status Date] + 1 and [Status Date] + 7,exclusive):

Using a task custom flag field:

iif( [% Complete] < 100 AND
(
DateValue([Start]) > DateValue([Status Date] + 1) AND
DateValue([Start]) < DateValue([Status Date] + 7)
),
Yes, No )