Fill blanks in date column using Name and period

[vinayvnn]

Hello Community, i have rendered with  below scenario where I need to fill blanks in date column based on the column "Name" but before I fill the blanks I also need to take into consideration of period.

I need to fill the date when date is blank and the line entry period should match the date which we are populating, I have given an example below reference for better understanding:

Name	Country	Period	Status	date
AAP	Dominican Republic	Jan 2023-Dec 2023	Complete	2/26/2024
AAP	Argentina	Jan 2023-Dec 2023	No Results expected
ABY	India	Jan'24-Mar'24	Complete	6/3/2024
ABY	India	Jan 2023-Dec 2023	Complete	3/12/2024
ABY	Denmark	Jan 2023-Dec 2023	No Results expected
ADE	Denmark	Jan 2023-Dec 2023	Complete	3/27/2024
AFR	United Kingdom	Jan'24-April'24	Complete	5/7/2024
AFR	United Kingdom	Jan 2023-Dec 2023	Complete	2/12/2024
AFR	Germany	Jan 2023-Dec 2023	No Results expected

Example

Name	Country	Period	Status	date
ABY	India	Jan'24-Mar'24	Complete	6/3/2024
ABY	India	Jan 2023-Dec 2023	Complete	3/12/2024
ABY	Denmark	Jan 2023-Dec 2023	No Results expected	3/12/2024

Thanks !

[MeganBowers]

Hi @vinayvnn, if I understand your question correctly, this can be done with one multi-row formula tool.

configuration: 

 

and the formula is:

if [Row-1:Name] = [Name] and isempty([date]) and [Row-1:Period] = [Period] then [Row-1:date] else [date] endif

This formula is saying that if the name in this row is the same as the row before, the date is empty, and the period matches the row before, fill the empty date with the date from the row before. Otherwise, keep the date as is.

Best,

Megan