Need Help with Spreadsheet raise dates and evaluations

%3CLINGO-SUB%20id%3D%22lingo-sub-3362512%22%20slang%3D%22en-US%22%3ENeed%20Help%20with%20Spreadsheet%20raise%20dates%20and%20evaluations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362512%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20use%20a%20step%20criteria%20for%20evaluations%20and%20raises.%20An%20example%20Step%201%20is%206%20months%20to%20the%20hire%20date%20and%202-5%20are%2012%20months%20(1%20Year)%20to%20the%20date%20of%20hire%20or%20the%206%20month%20date%20to%20the%20hire%20date.%20Example%3A%20Susie%20Q%20Rose%20was%20hired%20as%20a%20step%201%20on%20April%2015%2C%202022%20and%20will%20receive%20an%20increase%20in%206%20months%20depending%20on%20her%20work.%20Her%20new%20date%20and%20step%20change%20takes%20place%20she%20moves%20from%20step%201%20to%20step%202%20and%20now%20uses%20the%20October%2015%2C%202022%20as%20her%20new%20yearly%20%22date%20of%20hire%22.%20Every%20step%20up%20to%205%20will%20have%20an%20increase%20annually%20in%20October.%20Does%20anyone%20know%20what%20I%20need%20to%20do%20to%20show%20this%20for%20me.%20I%20would%20also%20like%20to%20add%20conditional%20formatting%20so%20I%20can%20send%20a%20reminder.%20I%20feel%20like%20it's%20obvious%20but%20I%20can't%20seem%20to%20get%20it.%20Thank%20you%20so%20much%20for%20any%20help.%20If%20more%20details%20are%20needed%20I%20will%20be%20glad%20to%20provide.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3362512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

We use a step criteria for evaluations and raises. An example Step 1 is 6 months to the hire date and 2-5 are 12 months (1 Year) to the date of hire or the 6 month date to the hire date. Example: Susie Q Rose was hired as a step 1 on April 15, 2022 and will receive an increase in 6 months depending on her work. Her new date and step change takes place she moves from step 1 to step 2 and now uses the October 15, 2022 as her new yearly "date of hire". Every step up to 5 will have an increase annually in October. Does anyone know what I need to do to show this for me. I would also like to add conditional formatting so I can send a reminder. I feel like it's obvious but I can't seem to get it. Thank you so much for any help. If more details are needed I will be glad to provide.

0 Replies