Fill blanks in date column using Name and period

Question

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  dateAAPDominican RepublicJan 2023-Dec 2023Complete2/26/2024AAPArgentinaJan 2023-Dec 2023No Results expected ABYIndiaJan'24-Mar'24Complete6/3/2024ABYIndiaJan 2023-Dec 2023Complete3/12/2024ABYDenmarkJan 2023-Dec 2023No Results expected ADEDenmarkJan 2023-Dec 2023Complete3/27/2024AFRUnited KingdomJan'24-April'24Complete5/7/2024AFRUnited KingdomJan 2023-Dec 2023Complete2/12/2024AFRGermanyJan 2023-Dec 2023No Results expected

Example

Name Country Period Status  dateABYIndiaJan'24-Mar'24Complete6/3/2024ABYIndiaJan 2023-Dec 2023Complete3/12/2024ABYDenmarkJan 2023-Dec 2023No Results expected3/12/2024

Thanks !

MeganBowers · Answer

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

Fill in blanks.yxmd