Hi @Alex , welcome to Q&A forum!
Yes, you are right, this requirement is achievable. :)
Please follow these steps:
1.Create a new view named "Days in Stage" and filter the items you want. I would suggest you use is equal to stage 1....OR is equal to stage2...OR ...... Create 7 is equal to to filter items:
2.Create a Calculated column and use this formula:
=IF(OR([Loan Stage]="Stage 1 - LOI",[Loan Stage]="Stage 7 - Closed"),Created,"N/A")
Let me explain:
What Calculated column can get is the time when this item was created: [Created], the time when it was modified [Modified], or the time in a new column. Using [Today] in a calculated column is pointless because the value get updated when the item is updated. In that way is it the same as the modified column.
I would suggest you create a Date and Time, For example we named it "CLOSED", then use this formula to calculate the number of days between the creation of the item and the closing time you specify:
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @Alex ,
Does this solution meet your needs? Is my suggestion helpful?
I am looking forward to your reply. Please don't hesitate to let us know if there are any questions.
Hi @Elsie Lu_MSFT - Yes, I've been playing around with this and it looks like it will work for us. Thank you for all your help.
Hi @Alex ,
Glad to hear that my advice is helpful. For a better user experience, please accept my solution as the answer, which will allow users with the same needs in the future to directly see the most useful content.
And any updates about this thread can be posted here, and we will continue to follow up.
Thank you for your understanding and support. :)
Have a nice day!
Sign in to comment