SPO Calculated Column not updating

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3166592%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ESPO%20Calculated%20Column%20not%20updating%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3166592%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20have%20a%20sharepoint%20list%20with%20calculated%20column%20and%20use%20a%20formula%20%7B%3DIF(ISNUMBER(%5BClosed%20Date%5D)%2C%22Closed%22%2CIF(%5BNext%20Action%20Date%5D%26gt%3B%3DTODAY()%2C%22Indue%22%2C%22Overdue%22))%7D.%3CBR%20%2F%3ESince%20I'm%20using%20TODAY()%20in%20formula%20it%20should%20be%20updated%20daily.%20I%20thing%20i%20need%20to%20create%20a%20flow%20but%20how%20to%20do%20that%20%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3166592%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

I have a sharepoint list with calculated column and use a formula {=IF(ISNUMBER([Closed Date]),"Closed",IF([Next Action Date]>=TODAY(),"Indue","Overdue"))}.
Since I'm using TODAY() in formula it should be updated daily. I thing i need to create a flow but how to do that ?

0 Replies