Hello. I'm new to SharePoint and did some searching on this forum and elsewhere but couldn't find a solution. Maybe I don't know enough to narrow my search :)
I have a Choice type column called "Loan Stage". The choices are:
Stage 1 - LOI
Stage 2 - Underwriting/Loan Processing
Stage 3 - Loan Documentation
Stage 4 - Boarding
Stage 5 - Closing
Stage 6 - Post Closing
Stage 7 - Closed
Our goal is to create a new View that shows time (in days) between Stage 1 - LOI and Stage 7 - Closed. The new view will be called "Days in Stage".
I think I need to create some new columns to get the date that the loan was in Stage 1 - LOI and when it was Stage 7 - Closed, then another calculated field to get the time (in days). Am I on the right track?

