Level 1
Level 2
Sign in to Community
Learn more
Sign in to view all badges
Expand my Community achievements bar.
This conversation has been locked due to inactivity. Please create a new post.
Can anyone help me find the minimum date of multiple columns per recipient? I have 7 date columns some of which are null.
Solved! Go to Solution.
Hi,
Maybe you can try to use a complex CASE function.
Case
Returns value 1 if the condition is verified. Otherwise, returns value 2
Case(When(<condition>, <value 1>), Else(<value 2>))
Ex: Case When Col1 < Col2 And Col1 < Col3 Then Col1 When Col2 < Col1 And Col2 < Col3 Then Col2 Else Col3
Case When Col1 < Col2 And Col1 < Col3 Then Col1 When Col2 < Col1 And Col2 < Col3 Then Col2 Else Col3
View solution in original post
I had thought of that initially but as 7 columns, I wanted to see if there was an easier solution. Thanks for your answer.
Views
Likes
Replies