Adjust my Formula to show tasks that start the following week

Home Forums Discussion Forum Adjust my Formula to show tasks that start the following week

Viewing 1 reply thread
  • Author
    Posts
    • #327916
      Will Shaw
      Guest

      Hi, I am trying to amend my formula to show all tasks that are due to start the following week from the status date.

      This formula is currently for tasks that are finishing in 7 days from the status date.

      IIf([% Complete]<100,IIf(DateValue([Finish])<(DateValue([Status Date])+1),”0″,IIf(DateValue([Finish])>(DateValue([Status Date])+7),”0″,”1″)),”0″).

      Help is greatly appreciated.

    • #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 )

Viewing 1 reply thread
  • You must be logged in to reply to this topic.