Task Start Date or Finish Date Needs To Be Updated RRS feed

  • Question

  • Hello, I am wondering why this formula does not work? Todya's date is 4/5/2018 .

    Switch(Date()>[Start] And [% Complete]=0,"Should Have Started", Date()<=[Finish] And [% Complete]<100,"Should Have Finished", Date ()<=[Start],"", Date()<=[Finish],"")

    Thursday, April 5, 2018 4:26 PM

All replies

  • Hi,

    When you say it is not working, what do you mean? It doesn't return the correct value or it returns an error?

    Just a comment, for the "should have finished", you should invert the inferior by a superior sign:

    Switch(Date()>[Start] And [% Complete]=0;"Should Have Started";Date()<=[Finish] And [% Complete]<100;"Should Have Finished";Date()<=[Start];"";Date()<=[Finish];"")

    Note also that your first and second condition could occur at the same time, so as soon as the first is fullfilled, the formula won't jump on the second condition.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller

    Friday, April 6, 2018 9:07 AM
  • Hello Guillaume, it is returning false data. So for example? Why does it say should have finished? Is there a way to correct this formula?

    Task Name Duration Start Finish Actual Finish Resource Names Actual Cost Update Dates
    Execute transition activities 82.76 days? Fri 5/18/18 Thu 8/30/18 NA $0.00 Should Have Finished

    Friday, April 6, 2018 4:00 PM
  • Try adding a 3rd line to graphical indicators where less  than z equals blank ICON

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Saturday, April 7, 2018 12:27 PM
  • Hello Michael, sorry I am not sure if I follow. Did you mean to add something like this?

    Monday, April 9, 2018 3:37 PM