Feb 14 2020 05:42 AM
I have a slightly complex SharePoint list which is populated (using Power Automate) from the output of two forms.
In addition to this, I have three columns which (were) calculating the length of time between various other columns e.g. caclulating the time of submitting the request to the time request completed, and the number of days the request has been open.
All of these were working well until about 10 days ago when the format of the SharePoint list changed (nobody has seems to have made any changes from my team) and the formulas have now stopped working.
Unfortunately versioning was not enabled so I can't go back to a previous point in time.
The calculations are:
=TEXT([Date Scope Assigned]-[Submission date],"h:mm:ss")
=TEXT(Completed_Submission_Date-[Date Scope Assigned],"h:mm:ss")
=DATEDIF([Date Scope Assigned],[Date Scoping Assignment completed],"d")
=TEXT(DATEDIF([Date Scope Assigned],Todays_Date,"d"),"#")
Submission Date (automated) = Single line text
Date Scope Assigned (manual) = Single line text
Date Scoping Assignment completed = Single line text
Today's Date (Automated) = Date and time
Does anyone have any ideas and to what happened, or what I'm missing?
thanks