Tracking PTO

03/03/21
Answered - Pending Review

Does anyone know of a formula that I can use to keep track of PTO days? Screenshot shows my layout. I want the employees to be able to enter their days off throughout the year and the total be subtracted as they enter.


I would also like the total days to carry into the next month. Any ideas??


Popular Tags:

Answers

  • RobertMeisch@Sysco[email protected] ✭✭✭✭✭

    Hey Samantha,

    In a new Column I would start with something like: =([PTO Days]@row - (SUM([1]@row+[2]@row ...[12]@row)

    Is that what you are looking for?

    Cheers,

    Robert Meisch

  • I am super new to Smartsheet.. Tried your example and the cell now says #UNPARSEABLE


    I added a row at the end like you suggested.


    Thanks!

Sign In or Register to comment.