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.
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!
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.
Hi Guys, I am looking for the formula to return value for a cell which is in the range. I have one smartsheet like above in the second smartsheet I have cell with date and for example if I have there 08/02/24 I want formula to give back Q3 FY25. Any ideas how can achieve this?
We have a daily task at the beginning of the day in which the first thing to do is to review and track the number of tickets accumulated outside of working hours from our system. The timestamp column comes from the system with the format "datetime", in another separate Smartsheet we are trying to show the date on the top…
©2024. All Rights Reserved Smartsheet Inc.