Add Forumla

Drister
Drister ✭
in Formulas and Functions

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.



image.png


· Share on FacebookShare on Twitter

Answers

  • Monique Odom-Stearn
    Monique Odom-Stearn ✭✭✭✭✭✭

    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-Stearn

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

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

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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!