Related to previously asked question
I now need to add an 'EndDate' column which takes the last day I was in a country and sets that as the End Date for all rows with the same ID. The column is shown below:
I have tried the following Multi-Row formula which is returning incorrect results:
IF [ID] = [Row-1:ID]
THEN [Date]
ELSE [Row+1:Date]
ENDIF
Many thanks
Solved! Go to Solution.
Hi @HenpetsGordres1 here's a workflow showing what you want to do:
I've put in two options depending on how your date is formatted
Hope that helps,
Ollie
Hello @HenpetsGordres1 ,
You cannot use the multi row formula since this tool only affects the curent row, the leading one and the trailing one.
For this use better the application @OllieClarke developed.
Regards
Many thanks, works brilliantly!