Add Forumla

I am trying to create a formula to keep track of vacation time. I would like my Amount of Vacation Used column to increase by 1 everytime my Date of Day off is filled out.


  • Monique_Odom_Comcast
    Monique_Odom_Comcast ✭✭✭✭✭✭

    Hello @Drister! In this situation, you could use a COUNT formula pointing to the cells under each person in the "Date of Day Off" column. If the cells are blank, the COUNT formula will ignore them, and the number will increase every time a new cell is filled with a date.

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!