Loading...
Quick Links

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

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #327916 Reply
    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 Reply

    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 2 posts - 1 through 2 (of 2 total)
Reply To: Adjust my Formula to show tasks that start the following week
Your information:




− 4 = 3