Forum Discussion
Solved
Find most recent date from multiple columns
I have a worklflow which assigns a phase (Phase A) to multiple people simultaneously. Each person may approve the workflow on a different date. I need to calculate the days between the last approva...
ddownard , Try a new column like
Switch( True(),
[Supervisor Date] > [Engineer Date] && [Supervisor Date] > [Writer Date], [Supervisor Date],
[Engineer Date] > [Writer Date] ,[Engineer Date] ,
[Writer Date]
)
The solution from amitchandak is the solution that produces the desired results. Hoping someone can tell me how to add three more columns to amitchandak's solution. Thanks!