Forum Discussion
Help setting up a formula for the assigned date column from previous dates
Perhaps in row 2:
=IF(COUNTIF($A$1:$A1,$A2)=0, $C2, MAXIFS($C$1:$C1, $A$1:$A1, $A2))
or
=LET(d, MAXIFS($C$1:$C1, $A$1:$A1, $A2), IF(d=0,$C2, d))
Fill down.
Perhaps in row 2:
=IF(COUNTIF($A$1:$A1,$A2)=0, $C2, MAXIFS($C$1:$C1, $A$1:$A1, $A2))
or
=LET(d, MAXIFS($C$1:$C1, $A$1:$A1, $A2), IF(d=0,$C2, d))
Fill down.
Thank you for the response.
The formula worked well on Row 2. But still I have issues with other rows, as you can see I highlighted a row that is showing as 03-Oct-2023, but in fact it has to be -4-Oct-2023. Also the mark X, a new Requisiton starts from that row and even that is showing up as 03-Oct-2023.
It works for me - see the attached workbook.
Hello HansVogelaar , thank you sending me the demo template. I tried to apply the formula but for some reason your getting the rite result and I still get the bad results. I have attached the template to the thread, please let me know if you want me to make any corrections.
That is because the values in columns B, C and E are text values that look like dates, not real dates.
In the attached version, I have used Data > Text to Columns to convert them to real dates.