Nested COLLECT question
I need help with creating the formula for the [PrevHours] column (below).
The expected logic for this formula would be: for a given row's ColValue, find the max date from all instances of ColValue, then find that row's Col2Value.
Project | Date | Hours | PrevHours
XYZ | 5/1/23 | 10 | ""
XYZ | 5/2/23 | 15 | 10
ABC | 5/1 | 100 | ""
XYZ | 6/1/23| 100 | 15
I want [PrevHours] to refer the previous latest date's entry for hours
Help Article Resources
Check out the Formula Handbook template!