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
-
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", .........................
Answers
-
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)))
-
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", .........................
-
TYVM
-
TYVM
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives