Creating a status column off multiple date fields

Question

I need an efficient way to create a singular column for status based off multiple columns with dates. I'm looking for the last non null column and return a status based off of it. A simple sample table.....

I was trying to create the formula with !isNull but it isn't coming out how I need.

SPUDCompletionAbandonmentFirst ProdSTATUS1/1/20232/1/2023 5/1/2023PRODUCING1/15/20233/1/2023  COMPLETION1/30/20232/15/20237/1/2023 ABANDONED

HomesickSurfer · Answer

Hi @jrkmorgan

Here goes...

IF 
!IsEmpty([First Prod]) AND !IsNull([First Prod]) THEN 'PRODUCING' ELSEIF 
IsEmpty([First Prod]) OR IsNull([First Prod]) AND !IsEmpty([Abandonment]) OR !IsNull([Abandonment]) THEN 'ABANDONED' 
ELSE 'COMPLETION' 
ENDIF

usmanbashir · Answer

That's what I built into the workflow. Let me know if results from workflow are not what you're looking for.

The workflow attached accommodates for more than just those 3 fields. Since you said that was just sample data, I made the assumption you wanted it more dynamic rather than to create an IF ELSE statement with hardcode column names. The workflow prioritizes the right most column than moves left until a value is found.

From there, you can adjust the workflow as needed.

Hope this helps!

jrkmorgan · Answer

If a certain column is null, it is the prior column's status I need. I.E. if the production date column is empty but completion is not, then the status would be completion. Basically for each row, the header of the column that has the last date.