Discussions

 View Only
  • 1.  Help on IF Statment

    Posted 09-15-2020 11:55
    Looking everywhere for the solution but cannot find an exact scenario to mine.

    Trying to write an IF statement so that my

    Column "Forecasted completion" will show blank if  "Actual finish is not null"  Otherwise If "Actual Finish is null" it will take "Actual Start Date" + "Duration Remaining"


    If([Duration Remaining]=null,[Actual Finish Date],[Actual Start Date]+[Duration Remaining])



    ------------------------------
    Rick Shaw Jr.

    ------------------------------


  • 2.  RE: Help on IF Statment

    Posted 09-15-2020 13:54
    Edited by Austin K 09-15-2020 13:56
    Try this one.

    If(isNull([Duration Remaining]),[Actual Finish Date],[Actual Start Date]+[Duration Remaining])

    If you wanted to do one where the duration is not null it is "not isNull" which is awful I know but that is how it works.

    Edit: Actually after reading the post more I believe your formula was wrong for what you wanted. This may do what the text says you want.

    If(isNull([Actual Finish], [Actual Start Date]+[Duration Remaining], "")


  • 3.  RE: Help on IF Statment

    Posted 09-15-2020 14:08
    Thank you Austin! 

    I was having syntax errors at first with your second solution, but i made a slight modification to 

    If(IsNull([Actual Finish Date]),[Actual Start Date]+[Duration Remaining])

    Seems to be working now.

    ------------------------------
    Rick Shaw
    ------------------------------