Discussions

 View Only
  • 1.  Number of days

    Posted 13 days ago
    I have two fields-  estimated completion date and date completed.  I am trying to create a formula to populate the number of days to complete the project ONLY if date completed is null.  I can create the formula and make it work if I leave out the completed part, put am getting an error when trying to incorporate the completed field.

    ------------------------------
    Angela Bowman
    ------------------------------


  • 2.  RE: Number of days

    Posted 13 days ago
    Can you post your current formula?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Number of days

    Posted 13 days ago
    If(
    not IsNull([Date completed]),"",
    ToDays([Estimated completion date]-Today()))

    ------------------------------
    Angela Bowman
    ------------------------------



  • 4.  RE: Number of days

    Posted 13 days ago
    I got it...  never mind! thanks.

    ------------------------------
    Angela Bowman
    ------------------------------