Forum Discussion
Jairacha
Nov 23, 2022Copper Contributor
Get Max date from a group of items in a sharepoint list and store it in another calculated column
Hello! I have a SharePoint list that contains multiple Employee Names in one column and various due dates in another column and I need to get the MAX date for each unique Employee Name and add this t...
RobElliott
Nov 24, 2022Silver Contributor
Jairacha you can't do this with a formula in a calculated column because it can't look at other items. You'd need to build something in a flow in Power Automate.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)