Need to count number of days

I need to count the number of days from today to a certain date in a column.

=TODAY() - IF([Assigned Date]@row <> "", [Assigned Date]@row, "0")

This is what I have, I want it to display the zero if there is no date in the assigned date column. I get invalid operation when there is not a date.

Thank you for your help.


Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    Sorry, I copied and pasted your ending and left a parenthesis in there. Try this:

    =IF(ISDATE([Assigned Date]@row), TODAY() - [Assigned Date]@row, 0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!