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

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.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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", .........................

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers