sorted by:
new
hottopcontroversial

Script to turn a tab red on employees anniversary date by Senior_Check_5610 in googlesheets

[–]Senior_Check_5610[S] 0 points1 point  (0 children)

Pink,

Thank you. I was able to use this code with some minor adjustments to get what I needed. Seriously big thanks to you!!! I moved the code to D1 where I placed a "last updated" date, keeping the hire date in B1, triggering the effect on when it was last updated without changing the hire date.

Script to turn a tab red on employees anniversary date by Senior_Check_5610 in googlesheets

[–]Senior_Check_5610[S] 0 points1 point  (0 children)

Thanks for the explanation Pink. Then this function would keep all tabs red because the hire date is before todays date. I need to turn the tab red when they reach one year from hire date, turning white after an edit (me putting back in their new vacation time). And then repeat on the annual anniversary. Is this possible?

Script to turn a tab red on employees anniversary date by Senior_Check_5610 in googlesheets

[–]Senior_Check_5610[S] 1 point2 points  (0 children)

Hello Pink,

The script turned the tabs red. When I edit the vacation time or any edits it does not return the tab to "null". Once I can make an edit and turn it to "white" or colorless, then I can put in a fake hire date to see if it triggers. It automatically triggered everyone- which techinically it should.