Groupby from a column with strings and date to get max date or null values

[Lumjing]

I have a string in the "Start date" column I want to group by "Numbers" and take the null first or max date else the string "Not applicable" in the Groupby  column. Can you please help in achieving this

[atcodedog05]

Hi @Lumjing 

Here is how you can do it.

Workflow:

Hope this helps : )