SOLVED

Sharepoint Online list calculated column with todays date not updating automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-2357640%22%20slang%3D%22en-US%22%3ESharepoint%20Online%20list%20calculated%20column%20with%20todays%20date%20not%20updating%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2357640%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20calculated%20column%20in%20SharePoint%20online%20list%20for%20calculating%20the%20number%20of%20days%20took%20to%20complete%20a%20task.%20The%20calculation%20is%20like%20todays%20date%20-task%20assigned%20date%20it%20gives%20the%20correct%20result%20when%20manually%20updating%20the%20column%20but%20its%20not%20automatically%20updating%20daily.%20please%20advice%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2357640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2358820%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20list%20calculated%20column%20with%20todays%20date%20not%20updating%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2358820%22%20slang%3D%22en-US%22%3EThis%20is%20by%20design.%20Calculated%20columns%20are%20computed%20only%20when%20editing%20the%20item.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2360368%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20list%20calculated%20column%20with%20todays%20date%20not%20updating%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360368%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1054751%22%20target%3D%22_blank%22%3E%40Anzil375%3C%2FA%3E%26nbsp%3Byou%20would%20need%20to%20use%20a%20flow%20in%20Power%20Automate%20to%20loop%20through%20the%20list%20and%20do%20the%20calculations%20on%20each%20item.%20The%20trigger%20would%20be%20a%20recurrence%20schedule%20trigger.%20But%20it%20couldn't%20update%20a%20calculated%20column%20so%20you'd%20need%20to%20make%20the%20column%20for%20the%20number%20of%20days%20a%20number%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2360646%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20list%20calculated%20column%20with%20todays%20date%20not%20updating%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1054751%22%20target%3D%22_blank%22%3E%40Anzil375%3C%2FA%3E%26nbsp%3BThis%20is%20a%20default%20behavior%20in%20SharePoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECalculated%20column%20values%20will%20be%20calculated%2Fupdated%20only%20when%3A%3C%2FP%3E%3CUL%3E%3CLI%3EA%20new%20item%20is%20created%3C%2FLI%3E%3CLI%3EAn%20existing%20item%20is%20updated%3C%2FLI%3E%3CLI%3ECalculated%20column%20formula%20is%20updated%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIf%20you%20want%20to%20update%20the%20column%20value%20daily%2C%20you%20can%20create%20a%20scheduled%20flow%20as%20mentioned%20by%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a calculated column in SharePoint online list for calculating the number of days took to complete a task. The calculation is like todays date -task assigned date it gives the correct result when manually updating the column but its not automatically updating daily. please advice

3 Replies
This is by design. Calculated columns are computed only when editing the item.
best response confirmed by Anzil375 (New Contributor)
Solution

@Anzil375 you would need to use a flow in Power Automate to loop through the list and do the calculations on each item. The trigger would be a recurrence schedule trigger. But it couldn't update a calculated column so you'd need to make the column for the number of days a number column.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

 

@Anzil375 This is a default behavior in SharePoint.

 

Calculated column values will be calculated/updated only when:

  • A new item is created
  • An existing item is updated
  • Calculated column formula is updated

If you want to update the column value daily, you can create a scheduled flow as mentioned by @RobElliott 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.