I work in HR and need to change the rate of an employee on their 2nd and 4th anniversary. My employee roster can be emailed and updated daily but I need to be notified somehow who hit their 2 and 4 year anniversary. Ideally it would create a planner task but even email notification would be good. So can something scan a sheet/table/column and based on condition of value of the cell it creates an action? Thanks!!!!
When an employee completes 2 years of service (celebrates a 2 year anniversary) at work - i need to increase their rate of pay. I hae a spreadsheet that has their hire date. I could put the spreadsheet into a sharepoint list but i need some way to identify employees when it is their 2 year anniversary and generate a notice to myself so that i can begin the process of increasing their rate of pay.
John Levesque recommend using the template that sends birthday emails since it will match the date but i am unable to make that work for a number of reasons - in that template it seems that the condition of @equals is looking for a column titled Birthday Date where as the description of the template says a column named BirthDate - see attached for error and list i created.