Can I do a COUNTIF for a non empty date field?


I want a formula the Original Days Left column to calculate a 6 in the last row in the below photo. Is there a way to do this?


  • Hollie Green
    Hollie Green ✭✭✭✭✭✭

    =[CX Days Estimate]@row-(Countif([Day1]@row:[Day10]@row,<>"") this is assuming your day columns go all the way over to Day 10 you would stop with whatever the last row you want to count is.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!