SharePoint list calculated columns no longer working

%3CLINGO-SUB%20id%3D%22lingo-sub-1173969%22%20slang%3D%22en-US%22%3ESharePoint%20list%20calculated%20columns%20no%20longer%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1173969%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20slightly%20complex%20SharePoint%20list%20which%20is%20populated%20(using%20Power%20Automate)%20from%20the%20output%20of%20two%20forms.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20this%2C%20I%20have%20three%20columns%20which%20(were)%20calculating%20the%20length%20of%20time%20between%20various%20other%20columns%20e.g.%20caclulating%20the%20time%20of%20submitting%20the%20request%20to%20the%20time%20request%20completed%2C%20and%20the%20number%20of%20days%20the%20request%20has%20been%20open.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20of%20these%20were%20working%20well%20until%20about%2010%20days%20ago%20when%20the%20format%20of%20the%20SharePoint%20list%20changed%20(nobody%20has%20seems%20to%20have%20made%20any%20changes%20from%20my%20team)%20and%20the%20formulas%20have%20now%20stopped%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20versioning%20was%20not%20enabled%20so%20I%20can't%20go%20back%20to%20a%20previous%20point%20in%20time.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThe%20calculations%20are%3A%3C%2FP%3E%3CP%3E%3DTEXT(%5BDate%20Scope%20Assigned%5D-%5BSubmission%20date%5D%2C%22h%3Amm%3Ass%22)%3C%2FP%3E%3CP%3E%3DTEXT(Completed_Submission_Date-%5BDate%20Scope%20Assigned%5D%2C%22h%3Amm%3Ass%22)%3C%2FP%3E%3CP%3E%3DDATEDIF(%5BDate%20Scope%20Assigned%5D%2C%5BDate%20Scoping%20Assignment%20completed%5D%2C%22d%22)%3C%2FP%3E%3CP%3E%3DTEXT(DATEDIF(%5BDate%20Scope%20Assigned%5D%2CTodays_Date%2C%22d%22)%2C%22%23%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESubmission%20Date%20(automated)%20%3D%20Single%20line%20text%3C%2FP%3E%3CP%3EDate%20Scope%20Assigned%20(manual)%20%3D%20Single%20line%20text%3C%2FP%3E%3CP%3EDate%20Scoping%20Assignment%20completed%20%3D%20Single%20line%20text%3C%2FP%3E%3CP%3EToday's%20Date%20(Automated)%20%3D%20Date%20and%20time%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20ideas%20and%20to%20what%20happened%2C%20or%20what%20I'm%20missing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1173969%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

0 Replies