Count days how many days have past and once completed stop counting.

I am trying to figure out how to counts the days from "doc date" to today, but when the completion date is entered it stops counting and remains there. Here is what I have so far..

=IF([Completion Date]@row<>, TODAY()-[Document Date]@row, [Completion Date]@row-[Document Date]@row)

I am getting error #UNPARSEAB with this formula.

Thanks for the help!

Answers

  • KPH
    KPH ✭✭✭✭✭✭

    You almost had it.

    You need a value for Completion Date not to equal. I have put in "" which means it isn't empty.

    I have also switched around the data to return.

    If it is true (i.e. there is a completion date) the value will be days between Completion Date and Doc Date.

    If false (i.e. there is no completion date) the value is the days between TODAY and Doc Date.

    =IF([Completion Date]@row <> "", [Completion Date]@row - [Document Date]@row, TODAY() - [Document Date]@row)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!