On a SharePoint file, I update pending employees to active in one column, and headcount to one in another. Their start date is in another column, which would be the trigger. What is the most effective way to automate this process?
Looking to automate updating of headcount column to 1.0 and employee status to Active, based on first day of joining.
Employee NameHeadcountEmployee StatusStart date
Brown, Sarah | 0.0 | joining | 12-Dec-22 |
Winter, Julie | 0.0 | joining | 15-Dec-22 |
Gray, Sandra | 0.0 | Joining | 5-Jan-23 |
David, John | 0.0 | Joining | 14-Jan-23 |