SharePoint TaskList App: Subtask to Main task completion %

%3CLINGO-SUB%20id%3D%22lingo-sub-875426%22%20slang%3D%22en-US%22%3ESharePoint%20TaskList%20App%3A%20Subtask%20to%20Main%20task%20completion%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875426%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22_3xX726aBn29LDbsDtzr_6E%20_1Ap4F5maDtT1E1YuCiaO0r%20D3IL3FD0RFy_mkKLPwL4%22%3E%3CDIV%20class%3D%22_292iotee39Lmt0MkQZ2hPV%20RichTextJSON-root%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20have%20a%20task%20list%20app%2C%20I%20have%20%25%20completion%20column%2C%20I%20have%20some%20tasks%20and%20subtasks.%20I'm%20trying%20to%20figure%20out%20the%20best%20way%20to%20make%20my%20main%20task%20%25%20complete%20be%20the%20average%20of%20its%20subtasks.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22_1hwEKkB_38tIoal6fcdrt9%20%22%3E%3CDIV%20class%3D%22_3-miAEojrCvx_4FQ8x3P-s%22%3E%3CDIV%20class%3D%22_1UoeAeSRhOKSNdY_h3iS1O%20_3m17ICJgx45k_z-t82iVuO%20_2qww3J5KKzsD7e5DO0BvvU%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-875426%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876355%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20TaskList%20App%3A%20Subtask%20to%20Main%20task%20completion%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876355%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415257%22%20target%3D%22_blank%22%3E%40Jtaylor239%3C%2FA%3E%26nbsp%3Byou%20can%20try%20to%20use%20Calculated%20value%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flist-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flist-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Faverage-function-73cdedbf-5954-492d-a32d-aa9fbc29c5ec%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Faverage-function-73cdedbf-5954-492d-a32d-aa9fbc29c5ec%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a task list app, I have % completion column, I have some tasks and subtasks. I'm trying to figure out the best way to make my main task % complete be the average of its subtasks.

 
1 Reply