Need to determine the stage of a house by the dates submitted

Robert S Fike

Our builders submit dates at each critical stage. I need to write a formula to show what stage the house is in by the looking at the latest date submitted. Any thoughts to what function i should use.

Trying to give the last column "Stage of Job", an answer of Slab, Frame, Cabinets or Final CO, based on the latest date entered.

Paul Newcome

You would need a nested IF statement working backwards.

=IF([Last Date]@row <> "", "Complete", IF([2nd to last date@row <> "", "Last Status", IF([3rd to last date]@row <> "", "2nd to last status", .........................

Robert S Fike

i created this formula, but i get a zero for the stage if there is a date or not.

=SUMIF([Package to the Field*]@row:[Final C.O. Date*]@row, IF(ISDATE([Package to the Field*]@row, 1, 0), ISDATE([Slab Inspection*]@row, 1, 0), ISDATE([Frame Inspection*]@row, 1, 0), ISDATE([Cabinet Install Date]@row, 1, 0), ISDATE([Final C.O. Date*]@row, 1, 0)))

Paul Newcome

You would need a nested IF statement working backwards.

=IF([Last Date]@row <> "", "Complete", IF([2nd to last date@row <> "", "Last Status", IF([3rd to last date]@row <> "", "2nd to last status", .........................

Robert S Fike

TYVM

Robert S Fike

TYVM

Paul Newcome

Happy to help. 👍️